Subscribe to Help Desk Geek.
As you can see, there is a dotted black line that points to what looks like an icon for a sheet. This means that there is a dependent cell on another sheet. Just as we wanted to see which cells are affected by the value of C3 in the example above, we may also want to see which cells affect the value of G3 or H3. As you can see, cells C3, D3, and E3 affect the value of the sum cell.
Those three cells are highlighted in a blue box with an arrow pointing to the sum cell. Founder of Help Desk Geek and managing editor. He began blogging in and quit his job in to blog full-time. He has over 15 years of industry experience in IT and holds several technical certifications.
Link Cells Between Sheets and Workbooks In Excel
If the cells are in a column, they'll be pasted into side-by-side in a row. This option pastes the formula, the number formatting, font, font size, shading, border. After copying a formula to a new location, it's important to check that its cell references are correct. For example, if you copy a formula two cells down and to the right of cell A1, then the cells references you used will be updated like this:.
Select the reference you want to change in the formula bar:.
Press F4 to switch between the absolute and relative reference combinations, and pick the one you want. For other formula paste options, click the arrow below Paste. You have many options here, but the most commonly used ones are:. Keep Source Formatting to paste the formula, the number formatting, font, font size, border, and shading of the original cell. The formula will be excluded.
The Link Cells command automatically pastes the correct syntax for you. By default, the Paste Options button appears when you paste copied data.
Click the Paste Options button, and then click Paste Link. Double-click the cell that contains the formula that you want to change. Excel highlights each cell or range of cells referenced by the formula with a different color. To move a cell or range reference to a different cell or range, drag the color-coded border of the cell or range to the new cell or range. In the formula bar , select the reference in the formula, and then type a new reference. Frequently, if you define a name to a cell reference after you enter a cell reference in a formula, you may want to update the existing cell references to the defined names.
Select the range of cells that contains formulas in which you want to replace cell references with defined names. In the Apply names box, click one or more names, and then click OK. In the formula bar , select the reference that you want to change. For more information about the different type of cell references, see Overview of formulas.
Create or change a cell reference
You can always ask an expert in the Excel Tech Community , get support in the Answers community , or suggest a new feature or improvement on Excel User Voice. Click the cell in which you want to enter the formula. Refers to the worksheet named Marketing 2.
Refers to the range of cells between B1 and B10, inclusively 3. Separates the worksheet reference from the cell range reference Click the cell in which you want to enter the formula.
Click the tab for the worksheet to be referenced.