Here are some useful shortcut keys in Excel that can
enhance your productivity:
Ctrl + C: Copy selected
cells.
Ctrl + X: Cut selected
cells.
Ctrl + V: Paste copied or
cut cells.
Ctrl + Z: Undo the last
action.
Ctrl + Y: Redo the last
undone action.
Ctrl + A: Select the
entire worksheet.
Ctrl + Home: Navigate to
cell A1.
Ctrl + Arrow keys (Up,
Down, Left, Right): Move to the edge of the current data region in the
direction of the arrow key.
Ctrl + Shift + Arrow keys
(Up, Down, Left, Right): Select cells from the current cell to the edge of the
data region in the direction of the arrow key.
Ctrl + Shift + L: Toggle
filter on/off for the selected range.
Ctrl + Shift + L + Arrow
keys (Up, Down): Select entire columns or rows within a filtered range.
Alt + =: AutoSum selected
cells.
F2: Edit the active cell.
Ctrl + Shift +
"+": Insert new cells, rows, or columns.
Ctrl + "-":
Delete cells, rows, or columns.
Ctrl + Shift +
"$": Apply currency format.
Ctrl + Shift +
"%": Apply percentage format.
Ctrl + Shift +
"#": Apply date format.
Alt + Enter: Start a new
line within a cell.
F4: Repeat the last action.
No comments:
Post a Comment