Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Skip to search results
Change which cells a formula refers to
When you enter or edit a formula , cell references and the borders around the corresponding cells are color-coded. Color-code d cell references If there are no...
Find and correct errors in formulas
Formula errors can result in error values as well as cause unintended results. Below are some tools to help find and investigate errors. Correct an error value,...
Move or copy a formula
Show All Hide All When you move a formula, the cell references within the formula do not change. When you copy a formula, the cell references may change based o...
Select cells that contain formulas
Do one of the following: Select the range that includes the type of cells you want to select. Click any cell to select all cells of this type on the active w...