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. |
