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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext