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.

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