If you want to display the named ranges that you are used the excel sheet, you can use the shortcut key “F3” shortcut key.

Use the Ctrl + Tilde Key in Excel sheet to toggle displaying the formula in the page. When End mode is on: (1) Use arrow keys to go to edge of current data area (2) Use Home to go to last cell (cell in lowest used row and right-most used column) of worksheet (3) Use Enter to go to last non-blank cell to the right. Use the shortcut key “Ctrl + Alt + V” to display the Paste Special Dialog Box where you can choose the type of paste that you want to perform. Excel Keyboard Shortcuts: Navigation And Selection. You can use the shortcut key “Ctrl” + F1 shortcut key to expand or collapse the Ribbon in Microsoft Excel 2016. This will add the formula to sumup all the cells of the columns.

Use the “Alt + “=” keyboard shortcut key. Autosum a Columnĭo you want to Autosum the column entries quickly ?. In order to navigate to the previous one, use “Ctrl + Shift + Tab”. Use Ctrl + Tab to navigate to the next open workbook. Next Workbook or Previous Workbookĭo you have multiple workbooks open and wish to navigate to the next open workbook ?. You can use the keyboard shortcut key “Ctrl” + PgDn to move to the next worksheet to the right and similarly, use the “Ctrl + PgUp” shortcut key to move to the worksheet to the left. There are times when you want to navigate or switch between worksheets within the same workbook. Simply use the “Ctrl” + W keyboard shortcut key. Don’t want to close the workbook using the close button in Excel ?.

Microsoft excel shortcut keys 2003