The ExcelZone Compendium Archive 1999-2007
CONTENTS
ExcelZone Hall of Fame
Excel tips and resources
Data entry
Navigation and shortcuts
Formatting
Dates & Numbers
Sort & Filter
Graphs & Charts
Printing
Worksheets & Ranges
Pivot Tables
Importing & Exporting
Continued...
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.
Or if you are already registered, login here
Comments
Re: Insert $ for absolute cell ref
Press F2 to go to edit mode. Then pressing the F4 key will toggle between $A$1, A$1 and $A1.
Hope that helps,
Barbara.
F4
keep tapping the F4 key
Insert $ for absolute cell ref
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?
Thanks