Jump to: File Operations, Actions, Editing, Formatting, Navigate, Shortcuts for Objects (Images,charts,buttons etc), Selection, Formula related shortcuts
Ctrl+N( not supported in chrome and safari ) | New File |
Ctrl+O | Open file |
Ctrl+Shift+S | Save As File |
Ctrl+P | Print File |
Ctrl+Z | Undo last action |
Ctrl+Y | Redo last action |
F4 (or) Ctrl+Y (or) Alt+Enter | Repeat last action |
Ctrl+Shift+ L | Filter |
Ctrl+R | Fill to The Right |
Ctrl+D | Fill Down |
Shift+F2 | Add / Edit cell note |
Ctrl+K | Add / Edit Hyperlink |
Alt +F11 | Open VBA Editor |
Alt+F8 | Run Macros / View Macros List |
Shift+F11 | Insert a new worksheet |
Ctrl+Shift+Plus | Insert Columns |
Ctrl+Alt+Plus | Insert Rows |
Ctrl+X | Cut |
Ctrl+C | Copy |
Ctrl+V | Paste |
Ctrl+Shift+ 1 | Format Cells |
Ctrl+F or F3 | Find within spreadsheet |
Ctrl+H | Replace |
Ctrl+F3 | Names Ranges |
Ctrl+Shift+Q | Toggle Auto Completion On / Off |
Alt+Arrow Down | Display the auto suggest list (Pick from List) |
Ctrl+Shift+ ; | Insert the current time in cell |
Ctrl+; | Insert the current date in cell |
Ctrl+Enter | Insert Line Break in Cell |
Backspace | Delete one character to left while typing in a cell |
Delete | Delete one character to right/left while typing in a cell |
Ctrl+Shift+F | Focus Formula Field |
Esc key | Cancel cell entry |
F2 | Edit active cell |
Ctrl+B (or) Ctrl+Shift+2 | Bold toggle for selection |
Ctrl+I (or) Ctrl+Shift+ 3 | Italic toggle for selection |
Ctrl+Shift+5 | Strikethrough toggle for selection |
Ctrl+U (or) Ctrl+Shift+4 | Underline toggle for selection |
Ctrl+Arrow Down | Data Region Down |
Ctrl+Arrow Up | Data Region Up |
Ctrl+Shift+N | Focus Name Box |
Alt+Arrow Right | Move to next worksheet in a spreadsheet |
Alt +Arrow Left | Move to previous worksheet in a spreadsheet |
Ctrl+ G | Go to cell command |
Ctrl+End | Go to last cell in data region |
Ctrl+Home | Go to first cell in data region |
Page Down | Down one screen |
Page Up | Up one screen |
Tab | Move to next cell in row |
Shift+Tab | Move to previous cell in row |
Ctrl+Arrow Left/ Ctrl+Arrow Right | Select Data Region to the Left / to the Right |
Tab | Navigate to the next object |
Shift+Tab | Navigate to the previous object |
F2 | Edit mode |
Esc | Return the focus to the active cell |
Esc | Cancel dragging the object |
Ctrl +Click | Select/Focus the object |
Arrow Keys | Move the selected object in the desired direction |
Ctrl+Arrow Keys | Snap the the object's left/top with the adjacent cell |
Ctrl+Shift+Arrow Keys | Snap the the object's right/bottom with the adjacent cell |
Ctrl+Shift+Arrow Left/Ctrl+Shift+ Arrow Right | Select Data Region to the Left/ to the Right |
Ctrl+Shift+Arrow Up/Ctrl+Shift+Arrow Down | Select Data Region Up/down |
Ctrl+Shift+Home | Select from current cell to the first cell A1 |
Ctrl+Shift+End | Select from current cell to the last cell in the data region |
Shift+Home | Select from current cell to the first cell in the same row |
Shift+End | Select from current cell to the last cell in the same row |
Ctrl +A | Select whole spreadsheet |
Ctrl+Space | Select column |
Shift+Space | Select row |
Ctrl+Shift+U | Toggle Expand and Collapse of Formula Bar |
Ctrl+Shift+Enter | Insert Array Formula on a range of cells |
Ctrl+/ | Select the range of array formula cells surrounding a cell |
= | Start a formula |
F9 | Recalculate Formulas |
F4 | Toggle absolute and relative references |
Alt+ = | Auto Sum |
Shift+F3 | Show Function Dialog Box |
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy