How to Input an Absolute Cell Reference in Microsoft Excel 2010
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