Other
= | Starts a Formula. |
Ctrl + ` | Toggles between the value layer and the formula layer (Options, Formulas tab - Show formulas in cells instead of their calculated results). |
Ctrl + Delete | Deletes to the end of the line. |
Ctrl + Insert | Copies the current selection to the clipboard. |
Ctrl + Shift + ( | Unhides any hidden rows within the selection. |
Ctrl + Shift + ) | Unhides any hidden columns within the selection. This does not work in Excel 2007. |
Ctrl + Shift + = | Displays the Insert dialog box when cells are selected. Inserts the same number of rows above the currently selected rows when rows are selected. Inserts the same number of columns before the currently selected columns when columns are selected. |
Ctrl + - | Displays the Delete dialog box when cells are selected. Deletes the currently selected rows when rows are selected. Deletes the currently selected columns when columns are selected. |
Ctrl + Esc | Displays the Windows Start Menu. |
Alt | Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys. |
Alt + Shift + Left Arrow | Ungroups the currently selected columns (or rows) or displays the UnGroup dialog box if cells are selected. |
Alt + Shift + Right Arrow | Groups the currently selected columns (or rows) or displays the Group dialog box if cells are selected. |
Alt + Backspace | Undo the last action. |
Alt + Spacebar | Activates the Control Box in the top left hand corner. |
Alt + - | Displays the Excel application control menu. |
End | Toggles between switching End Mode on or off. |
Scroll Lock | Toggles between switching Scroll Lock on or off. |
Shift + Insert | Pastes the entry from the clipboard. |
Alt + Down Arrow | Displays the Autofilter drop-down when the active cell is in the table heading. |
= Starts a Formula. |
Ctrl + ` Toggles between the value layer and the formula layer (Options, Formulas tab - Show formulas in cells instead of their calculated results). |
Ctrl + Delete Deletes to the end of the line. |
Ctrl + Insert Copies the current selection to the clipboard. |
Ctrl + Shift + ( Unhides any hidden rows within the selection. |
Ctrl + Shift + ) Unhides any hidden columns within the selection. This does not work in Excel 2007. |
Ctrl + Shift + = Displays the Insert dialog box when cells are selected. Inserts the same number of rows above the currently selected rows when rows are selected. Inserts the same number of columns before the currently selected columns when columns are selected. |
Ctrl + - Displays the Delete dialog box when cells are selected. Deletes the currently selected rows when rows are selected. Deletes the currently selected columns when columns are selected. |
Ctrl + Esc Displays the Windows Start Menu. |
Alt Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys. |
Alt + Shift + Left Arrow Ungroups the currently selected columns (or rows) or displays the UnGroup dialog box if cells are selected. |
Alt + Shift + Right Arrow Groups the currently selected columns (or rows) or displays the Group dialog box if cells are selected. |
Alt + Backspace Undo the last action. |
Alt + Spacebar Activates the Control Box in the top left hand corner. |
Alt + - Displays the Excel application control menu. |
End Toggles between switching End Mode on or off. |
Scroll Lock Toggles between switching Scroll Lock on or off. |
Shift + Insert Pastes the entry from the clipboard. |
Alt + Down Arrow Displays the Autofilter drop-down when the active cell is in the table heading. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext