The ExcelZone Hall of Fame
Excel tips and resources
Data entry
Shortcuts and navigation
Formatting
Dates & Numbers
Sort & Filter
Graphs & Charts
Printing
Worksheets & Ranges
Pivot Tables
Importing & Exporting
ODBC and Query
Functions & Formulae
SUMIF & IF
Lookup
Macros
Visual Basic programming
Hide & Protect
Excel applications and templates
Working with accounts data
Linking to other applications
Network issues and Excel Services
Troubleshooting
Replies (3)
Please login or register to join the discussion.
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
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