The ExcelZone Compendium Archive 1999-2007

Kashflow logo


  • 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

  • ODBC and Query

  • Functions & Formulae

  • SUMIF & IF

  • Lookups

  • Macros

  • Visual Basic programming

  • Hide & Protect

  • Excel applications and templates

  • Working with accounts data

  • Linking to other applications

  • Network issues and Excel Services

  • Troubleshooting

  • ExcelZone links

    The ExcelZone Hall of Fame

  • Top 20 Excel tips from Chris Bales (2000)

  • Gail Perry's Excel Almanac - Top Productivity Tips

  • Excel navigation tips from AccountingWEB members

  • ...
  • Please Login or Register to read the full article

    The full article is available to registered 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.


    Please login or register to join the discussion.

    By mung1
    03rd Jun 2006 13:13

    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 (0)
    By barb24
    05th Nov 2006 10:15

    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,

    Thanks (0)
    04th Jul 2006 22:48

    keep tapping the F4 key

    Thanks (0)