On transition navigation keys: Tools menu, Options
Is there a keyboard shortcut that will move straight down to the same cell For example starting at Sheet1C4Control+PgDn will take you to the next sheet, but will go to the cell that was selected previously on that sheet. Rightmost nonblank cell in the current row Keyboard shortcut to go to next sheet, same cell. Moving and Scrolling in End ModeĪppears in the status bar when End mode is selected. Scroll through the list or use the Index to quickly go to the section you want. Press ALT+T and then O ( Tools menu, Options command), pressĬTRL+TAB until the Edit tab is selected, and then change the Move Below is a huge list of Excel keyboard shortcuts you can use to work faster. Let’s look at the different shortcuts to summarize your data using a pivot table. You can change the direction of movement after pressing ENTER or SHIFT+ENTER: Now that we have looked at the different shortcut keys for formatting cells, rows, and columns, it is time to jump into understanding an advanced topic in Excel, i.e. To left within the selected range (or up if only one column is selected) Right within the selected range (or down if only one column is selected) Previous pane in a worksheet that has been split
F5 Go to F6 Next pane (if split) F7 Spell check F8 Select anchor F9 Calculate F10 Activate menu bar F11 Creates chart sheet F12 Save as ALT + F8 MACRO box ALT + F11 Visual basic editor SHIFT + F1 Context sensitive help SHIFT + F11 Insert new sheet SHIFT + F5. F1 Help menu F2 Go into cell / go out F3 Paste name in function F4 Absolute reference rpt. Ctrl + Arrow Key Move to the left, right, upper or lower most part current data region. Enter array formula CTRL + SHIFT + ENTER Selects current region CTRL + SHIFT +. Ctrl + Page Up Move to the previous worksheet in the workbook.
Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right. Ctrl + Page Down Move to the next worksheet in the workbook. A clear list of over 200 Excel shortcuts for both Windows and Mac, side-by-side. Ctrl + Tab Move between open Excel workbooks. Next pane in a worksheet that has been split (Window menu, Split Here are 8 great keyboard shortcuts to speed up your navigation through Excel workbooks.
keyboard.įor keyboard shortcuts in which you press two or more keys together, the keys to press are separated by a plus sign,įor shortcuts in which you press keys one after the other, the keys to press are separated by a comma,Ĭell on the worksheet, in the bottom-most used row of the rightmost used Keys on other layouts may not correspond exactly to the keys on a U.S.
Keys for Moving and Scrolling on WorksheetsĪll shortcut keys are based on the U.S. Working with Databases and Lists] įor Working with PivotTables and PivotCharts] [ Keys for Workbooks] [ Keys for Printing and Previewing Spreadsheet Moving between Worksheet Panes, Worksheets, and Excel Shortcut Keys: Keys for Moving and Scrolling on a Worksheet