Ctrl + Letters
| Ctrl + A | Selects the entire worksheet, or the current region if the active cell contains a value, or the whole table (excluding heading) if the active cell is in a table. It can also display the Function Arguments dialog box if you have typed a function. |
| Ctrl + A, A | Selects the whole worksheet if the active cell contains a value. |
| Ctrl + B | Toggles bold on the current selection. |
| Ctrl + C | Copies the current selection to the clipboard. |
| Ctrl + D | Enters the value from the cell directly above into the active cell. |
| Ctrl + E | Populates the selected cells using a Flash Fill recognised pattern. |
| Ctrl + F | Displays the Find tab of the Find and Replace dialog box. |
| Ctrl + G | Displays the GoTo dialog box. |
| Ctrl + H | Displays the Replace tab of the Find and Replace dialog box. |
| Ctrl + I | Toggles italics on the current selection. |
| Ctrl + K | Displays the Insert Hyperlink dialog box. |
| Ctrl + L | Displays the Create Table dialog box. |
| Ctrl + N | Creates a New (default) workbook. |
| Ctrl + O | Displays the Open Options on the File tab. |
| Ctrl + P | Displays the Print Options on the File tab. |
| Ctrl + Q | Displays the Quick Analysis smart tag. |
| Ctrl + R | Enters the value from the cell directly to the left into the active cell. |
| Ctrl + S | Saves. Displays the Save As Options on the File tab when its a new workbook. |
| Ctrl + T | Displays the Create Table dialog box. |
| Ctrl + U | Toggles underlining on the current selection. |
| Ctrl + V | Pastes the entry from the clipboard. You can also use Enter to paste the entry. |
| Ctrl + W | Closes the active workbook or window (saving first). |
| Ctrl + X | Cuts the current selection to the clipboard. |
| Ctrl + Y | Redo the last Excel operation. This can be used to redo multiple steps. This can also be used to repeat applied formatting. |
| Ctrl + Z | Undo the last Excel operation. This can be used to undo multiple steps. |
| Ctrl + A Selects the entire worksheet, or the current region if the active cell contains a value, or the whole table (excluding heading) if the active cell is in a table. It can also display the Function Arguments dialog box if you have typed a function. |
| Ctrl + A, A Selects the whole worksheet if the active cell contains a value. |
| Ctrl + B Toggles bold on the current selection. |
| Ctrl + C Copies the current selection to the clipboard. |
| Ctrl + D Enters the value from the cell directly above into the active cell. |
| Ctrl + E Populates the selected cells using a Flash Fill recognised pattern. |
| Ctrl + F Displays the Find tab of the Find and Replace dialog box. |
| Ctrl + G Displays the GoTo dialog box. |
| Ctrl + H Displays the Replace tab of the Find and Replace dialog box. |
| Ctrl + I Toggles italics on the current selection. |
| Ctrl + K Displays the Insert Hyperlink dialog box. |
| Ctrl + L Displays the Create Table dialog box. |
| Ctrl + N Creates a New (default) workbook. |
| Ctrl + O Displays the Open Options on the File tab. |
| Ctrl + P Displays the Print Options on the File tab. |
| Ctrl + Q Displays the Quick Analysis smart tag. |
| Ctrl + R Enters the value from the cell directly to the left into the active cell. |
| Ctrl + S Saves. Displays the Save As Options on the File tab when its a new workbook. |
| Ctrl + T Displays the Create Table dialog box. |
| Ctrl + U Toggles underlining on the current selection. |
| Ctrl + V Pastes the entry from the clipboard. You can also use Enter to paste the entry. |
| Ctrl + W Closes the active workbook or window (saving first). |
| Ctrl + X Cuts the current selection to the clipboard. |
| Ctrl + Y Redo the last Excel operation. This can be used to redo multiple steps. This can also be used to repeat applied formatting. |
| Ctrl + Z Undo the last Excel operation. This can be used to undo multiple steps. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext