Paul Wherly

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

ExcelAbCel1

  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]

Shelley Fishel

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More