Easy Explanation Notes with Examples

Creating Cell References in Excel

In Excel, a cell reference is an address to a cell or a range of cells on a worksheet, it uses in formulas so that Excel find those values that you want to calculate in a formula. For example, cell C1 below has the sum formula which refers to cell A1 and B1 i.e. add values in cell A1 and B1.

Result.

Creating a cell reference on the same worksheet

To create a cell reference on the same worksheet, do the following steps:

1- Click the cell in which you want to enter the formula, type = (equal sign).

2- Reference one or more cells, in the example below, reference is created for more than one cells. Select the cell range by pressing and holding Shift then pressing Upward arrow key.


3- Press Ctrl+Shift+Enter. Result.

Note: if you have single cell reference then press Enter only instead of the above command.

Creating a cell reference to another worksheet

1- Again type = (equal sign) in cell where you want to enter a formula e.g. we will add SUM formula.

2- Click on the worksheet to be referenced e.g. Sheet1. You can also use Ctrl + Page Up/ Page Down buttons to reach that worksheet.

3- Select a cell or cell ranges to be referenced and press Enter. Result.

Next: Changing a cell reference




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved