The ExcelZone Hall of Fame
The full article is available to registered AccountingWEB.co.uk 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 refI 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 refPress F2 to go to edit mode. Then pressing the F4 key will toggle between $A$1, A$1 and $A1.Hope that helps,Barbara.
F4keep tapping the F4 key