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
- Select the cell where you require the first formula
- Enter the formula as normal
- Press F4 after the cell reference you wish to be absolute (Dollar signs will appear around the cell reference)
- Press Enter
- AutoFill the formula
To change an existing formula that needs an absolute cell reference
- Click on the cell containing the formula you wish to change
- Double-click on the cell (or Click next to the formula on the Formula bar)
- Move the cursor so that it sits next to the cell reference you wish to make absolute
- Press F4
- Dollar signs will appear around the cell reference
- Press Enter
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
