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 + DeleteDeletes to the end of the line.
Ctrl + InsertCopies 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 + EscDisplays the Windows Start Menu.
AltToggles the display of the ribbon shortcut keys, otherwise known as Access Keys.
Alt + Shift + Left ArrowUngroups the currently selected columns (or rows) or displays the UnGroup dialog box if cells are selected.
Alt + Shift + Right ArrowGroups the currently selected columns (or rows) or displays the Group dialog box if cells are selected.
Alt + BackspaceUndo the last action.
Alt + SpacebarActivates the Control Box in the top left hand corner.
Alt + -Displays the Excel application control menu.
EndToggles between switching End Mode on or off.
Scroll LockToggles between switching Scroll Lock on or off.
Shift + InsertPastes the entry from the clipboard.
Alt + Down ArrowDisplays 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