20 essential keyboard shortcuts in Microsoft Excel
Shortcut Key | Action / Function | Description |
---|---|---|
Ctrl + C | Copy | Copies the selected cells or content to the clipboard. |
Ctrl + V | Paste | Pastes the copied or cut content into the selected cell or range. |
Ctrl + X | Cut | Cuts the selected cells to move them elsewhere. |
Ctrl + Z | Undo | Reverses the last action, helpful when you make a mistake. |
Ctrl + Y | Redo | Reapplies the last undone action. |
Ctrl + S | Save | Saves the current Excel workbook. |
Ctrl + P | Opens the Print dialog to print the sheet. | |
Ctrl + F | Find | Searches for specific text or values in the sheet. |
Ctrl + H | Find and Replace | Finds and replaces specific content in the workbook. |
Ctrl + A | Select All | Selects the entire worksheet or data region. |
Ctrl + Arrow Key | Move to Edge | Moves to the edge of data in a direction; useful for navigating large tables. |
Ctrl + Space | Select Column | Selects the entire column of the active cell. |
Shift + Space | Select Row | Selects the entire row of the active cell. |
Ctrl + Shift + L | Toggle Filter | Adds or removes filters in a data range. |
Ctrl + T | Create Table | Converts a range into an Excel Table with filtering and formatting. |
Alt + = | AutoSum | Inserts the SUM function for adjacent numbers. |
F2 | Edit Cell | Activates in-cell editing for the selected cell. |
Ctrl + Shift + "+" (plus) | Insert Cells | Inserts rows or columns at the current selection. |
Ctrl + "-" (minus) | Delete Cells | Deletes selected cells, rows, or columns. |
Ctrl + 1 | Format Cells | Opens the Format Cells dialog for detailed formatting options. |