Excel Tips – Most useful Keyboard Shortcuts

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