Ctrl + Letters

Ctrl + ASelects 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, ASelects the whole worksheet if the active cell contains a value.
Ctrl + BToggles bold on the current selection.
Ctrl + CCopies the current selection to the clipboard.
Ctrl + DEnters the value from the cell directly above into the active cell.
Ctrl + EPopulates the selected cells using a Flash Fill recognised pattern.
Ctrl + FDisplays the Find and Replace dialog box with the Find tab active.
Ctrl + GDisplays the GoTo dialog box.
Ctrl + HDisplays the Find and Replace dialog box with the Replace tab active.
Ctrl + IToggles italics on the current selection.
Ctrl + KDisplays the Insert Hyperlink dialog box.
Ctrl + LDisplays the Create Table dialog box.
Ctrl + NCreates a New (default) workbook.
Ctrl + ODisplays the Open Options on the File tab.
Ctrl + PDisplays the Print Options on the File tab.
Ctrl + QDisplays the Quick Analysis smart tag.
Ctrl + REnters the value from the cell directly to the left into the active cell.
Ctrl + SSaves. Displays the Save As Options on the File tab when its a new workbook.
Ctrl + TDisplays the Create Table dialog box.
Ctrl + UToggles underlining on the current selection.
Ctrl + VPastes the entry from the clipboard. You can also use Enter to paste the entry.
Ctrl + WCloses the active workbook or window (saving first).
Ctrl + XCuts the current selection to the clipboard.
Ctrl + YRedo the last Excel operation. This can be used to redo multiple steps. This can also be used to repeat applied formatting.
Ctrl + ZUndo 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 and Replace dialog box with the Find tab active.
Ctrl + G
Displays the GoTo dialog box.
Ctrl + H
Displays the Find and Replace dialog box with the Replace tab active.
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.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext