The ExcelZone Compendium Archive 1999-2007

3

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

  • 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

    Replies

    Please login or register to join the discussion.

    avatar
    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

    Thanks (0)
    avatar
    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,
    Barbara.

    Thanks (0)
    avatar
    04th Jul 2006 22:48

    F4
    keep tapping the F4 key

    Thanks (0)