The ExcelZone Compendium Archive 1999-2007


» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.


Insert $ for absolute cell ref

mung1 | | Permalink

I have forgotten how to edit and insert $ sign into a cell reference by toggling 2 keys. e.g edit cell ref A2 to $A$2.

Can any remember this 2 key key stroke?


Re: Insert $ for absolute cell ref

barb24 | | Permalink

Press F2 to go to edit mode. Then pressing the F4 key will toggle between $A$1, A$1 and $A1.
Hope that helps,


David Carter | | Permalink

keep tapping the F4 key