Quick Tip for Microsoft Excel 2010

Here is How to Input an Absolute Cell Reference in Microsoft Excel 2010.

To input an absolute cell reference while creating a formula

1. Select the cell where you require the first formula
2. Enter the formula as normal
3. Press F4 after the cell reference you wish to be absolute (Dollar signs will appear around the cell reference)
4. Press Enter
5. AutoFill the formula

To change an existing formula that needs an absolute cell reference

1. Click on the cell containing the formula you wish to change
2. Double-click on the cell (or Click next to the formula on the Formula bar)
3. Move the cursor so that it sits next to the cell reference you wish to make absolute
4. Press F4
5. Dollar signs will appear around the cell reference
6. Press Enter

[callout]To learn more about Absolute Cell Reference and to see how we can help your organisation improve their performance with Microsoft Excel 2010 give us a call 020 8203 1774[/callout]