Which are amongst the most useful Keyboard Shortcuts?

  • Display or Hide the ribbon?

Press CTRL+ F1.

  • Go to the last used cell in a sheet?

Press CTRL + End.

  • Select cells from any cell to the last cell in the sheet’s used range?

Press Shift + Ctrl + End to select cells from any cell to the last cell in the sheet’s used range and Shift + Ctrl + Home to select cells from any cell to the first cell (A1) in the sheet’s used range

  • Move to the next / previous sheet?

Press CTRL + Pg Up to go to next sheet and CTRL+ Pg Dwn to go to previous sheet.

  • Open new workbook?

Press Ctrl + N

  • Insert new sheet?

Press Shift + F11

  • Select entire row, Select entire column?

Press CTRL + Space Bar to select entire column and Shift + Space Bar to select entire row.

  • Insert current Date

Press CTRL ; to insert current date

  • Insert current time?

Press Shift + CTRL + ; to insert current time

More Under Finance

Posted Under

Category : Finance (3456)
Type : Articles (14349)
Tags : Excel Tips (35)

0 responses to “Excel Tips – Most useful Keyboard Shortcuts”

  1. vivek says:

    grt..

  2. bharati says:

    thanks & please send more shortcut

  3. Amit says:

    Thanks for share valuable info. for learner …………….

  4. Shrikant says:

    Thanks……
    It is really Helpful”””’

  5. CA Bhavin Mehta says:

    Thanks for sharing the info. Really helps…….

Leave a Reply

Your email address will not be published. Required fields are marked *