Other useful shortcut keys Frequently used shortcuts This table lists the most frequently used shortcuts in Excel. To do this Press Close a workbook. Ctrl+W Open a workbook. Ctrl+O Go to the Home tab. Alt+H Save a workbook. Ctrl+S Copy selection. Ctrl+C Paste selection. Ctrl+V Und...
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...
Knowing and using Keyboard Shortcuts is one of thoseExcel Skillsthat can help you save a ton of time every day. There are more than 500 keyboard shortcuts that you can use in Excel, but the problem is not all of those can be helpful for you. That’s why I have listed only the 82...
ShortcutWindowsMacWeb Select the first visible cell in the sheet (or bottom-right of freeze panes)Ctrl+HomeFn+Ctrl+←Ctrl+Home Select the last used cell in the sheetCtrl+EndFn+Ctrl+→Ctrl+End Select first cell in the row of the active cellHomeFn+←Home ...
Cell edit mode Shortcut Keys in Excel Edit the active cellF2 BackspaceDelete Cancel entryEsc DeleteFn+Delete Delete character to the left of cursorBackspace Delete character to the right of cursorDelete Delete to end of lineCtrl+Delete
Keyboard Shortcut to Delete Row in the Excel Select any cell in the row you want to delete. Press Shift + Space to select the entire row. And in the end, press use the below mentioned keys: Windows :Ctrl+Minus Sign (-) Mac:Command+Minus Sign (-) ...
Show all formulas in the Excel sheet. Use the same shortcut key to toggle back to showing formulated values Ctrl+Shift+~ (Tilde) ApplyGeneralformatting to selected cells Ctrl+Shift+! (Exclamation) ApplyNumberformatting to selected cells
Display the shortcut menu for the selected command. ENTER Move the focus to each command on the Ribbon, forward or backward respectively. TAB, SHIFT+TAB Move down, up, left, or right among the items on the Ribbon, respectively. DOWN ARROW, UP ARROW, LEFT ARROW, RIGHT ARROW ...
Delete to the End of the line (from the cursor)Ctrl + Delete Cancel EntryEsc Navigation Shortcuts in Excel What it Does?Windows Shortcut Move One Cell Up↑ Move One Cell Down↓ Move One Cell to the Right→ Move One Cell to the Left← ...
Keyboard Shortcuts for Cells, Columns, and Rows With these shortcuts, you can select, insert, delete,hide, and unhidecells, columns, and rows. Keyboard Shortcuts for Navigating a Sheet Move around within a sheet or go to the next or previous one with a few simple key presses using the ...