Excel shortcuts keys

Navigating and viewing data

ShortcutDescription
Ctrl + F1Show / hide the Excel Ribbon. Hide the ribbon to view more than 4 rows of data.
Ctrl + TabSwitch to the next open Excel workbook.
Ctrl + PgDownSwitch to the next worksheet. Press Ctrl + PgUp to switch to the previous sheet.
Ctrl + GOpen the “Go to” dialog. Pressing F5 displays the same dialog.
Ctrl + FDisplay the “Find” dialog box.
HomeReturn to the 1st cell of the current row in a worksheet.
Ctrl + HomeMove to the beginning of a worksheet (A1 cell).
Ctrl + EndMove to the last used cell of the current worksheet, i.e. the lowest row of the rightmost column.

Share This:

Leave a Reply

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

PHP Code Snippets Powered By : XYZScripts.com