Excel shortcuts

The Absolute Reference Shortcut in Excel You Need to Know

If you work with Excel on a regular basis, you know that one of the most tedious and time-consuming tasks is creating formulas that reference cells in other worksheets. For example, let's say you have a workbook with three worksheets, and you want to sum the values in cells A1:A5 on each worksheet. You could create a formula on each worksheet that references the cells on the other two worksheets, but that would be a lot of work. Fortunately, there's a shortcut that you can use to create absolute references to cells in other worksheets.

The shortcut is to use the 'F3' key. When you press 'F3', Excel will display the 'Paste Name' dialog box. From here, you can select the worksheet that you want to reference. Once you've selected the worksheet, press the 'OK' button and Excel will insert the reference into the formula.

For example, let's say you want to reference cells A1:A5 on the 'Sheet1' worksheet. You would press the 'F3' key, select 'Sheet1' from the 'Paste Name' dialog box, and then press the 'OK' button. Excel would then insert the following into the formula:

[Sheet1]A1:A5

You can then use this reference in your formula. For example, if you wanted to sum the values in cells A1:A5 on each worksheet, you could use the following formula:

=SUM([Sheet1]A1:A5)+SUM([Sheet2]A1:A5)+SUM([Sheet3]A1:A5)

As you can see, this shortcut can save you a lot of time and effort when creating formulas that reference cells in other worksheets. So next time you need to create a formula like this, remember to use the 'F3' key!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.