3. Keyboard Shortcuts for Excel WorksheetActionsWindows Shortcut Insert new worksheet Shift + F11 Go to the next worksheet Ctrl + PgDn Go to the previous worksheet Ctrl + PgUp Rename current worksheet Alt + O, H, R Delete current worksheet Alt + E, L Display Move or Copy Alt + E, M...
ShortcutWindowsMacWeb Insert new worksheetShift+F11Fn+Shift+F11Shift+F11 Delete selected worksheetsAlt,E,LAlt,H,D,S Rename current worksheetAlt,O,H,R Go to next worksheetCtrl+PgDnFn+Ctrl+↓Ctrl+Alt+PgDn Go to previous worksheetCtrl+PgUpFn+Ctrl+↑Ctrl+Alt+PgUp ...
Shortcut keysFunctionality Ctrl+NOpen a new worksheet. Ctrl+SSave a workbook. Ctrl+CCopy selected data. Ctrl+VPaste the selected data. Ctrl+ZUndo recent changes. Ctrl+OOpen a workbook. Ctrl+WClose a workbook. Ctrl+BBold formatting. ...
Shift+F11: inserts a new worksheet. Alt+F11: opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA). F12 F12 alone: displays the Save As dialog box. Top of Page Other useful...
Ctrl+Tab - Goes to next worksheet tab. Ctrl+U - Applies or removes underlining. Ctrl+V - Inserts the contents of the Clipboard at the insertion point and replaces any selection. Ctrl+W - Closes the selected workbook window. Ctrl+X - Cuts the selected cells. Ctrl+Y - Repeats the last...
Here is the keyboard shortcut that solves this problem. To go to the previous worksheet: CONTROL PAGEUP To go to the next worksheet: CONTROL PAGEDOWN Note that if you continue to hold the keys, it will keep on moving on to the previous/next worksheet. ...
Extends the selection of cells to the beginning of the worksheet. 0 Ctrl+↑ Shift+Tab Goes to previous worksheet tab 0 Ctrl+Tab Goes to next worksheet tab 0 Ctrl+U Applies or removesunderlining 0 Ctrl+V Inserts the contents of the Clipboard at the insertion point and replaces any selection...
PressCtrl+Shift+:to enter the current time. PressCtrl+;for the current date. Note the shortcut enters thecurrenttime, not a formula. To put both the date and time in one cell, type either keystroke, a space, then the other keystroke. Excel will interpret it as the proper date and tim...
General Excel Shortcut Copy selected cells Ctrl+C Create chart in new worksheet F11 Create embedded chart Alt+F1 Cut selected cells Ctrl+X Display find and replace Ctrl+F Display find and replace, replace selected Ctrl+H Display the Paste Special dialog box Ctrl+AltV Find next match Shift+...
Shift Shortcuts Shift+F2 Insert a note in the selected cell Shift+F3 Brings up theInsert Functiondialog box Shift+F6 Switches between the Ribbon, Status bar, Task Pane (if visible), worksheet tabs, and the worksheet Shift+F8 Select any cell and then press this shortcut. Next, add a non...