MS Excel Shortcut Keys
Here are more than 50 Microsoft Excel commands and shortcuts that are commonly used and can be helpful in an exam-oriented context:
Basic Navigation and Selection:
- Move to the next cell:
Tabor→ - Move to the previous cell:
Shift + Tabor← - Move to the next worksheet:
Ctrl + Page Down - Move to the previous worksheet:
Ctrl + Page Up - Select the entire row:
Shift + Space - Select the entire column:
Ctrl + Space - Select the entire worksheet:
Ctrl + A - Select a range of cells: Click and drag, or
Shift + Arrow keys - Extend the selection:
Shift + Arrow keys
Editing and Formatting:
- Cut:
Ctrl + X - Copy:
Ctrl + C - Paste:
Ctrl + V - Undo:
Ctrl + Z - Redo:
Ctrl + YorCtrl + Shift + Z - Bold:
Ctrl + B - Italic:
Ctrl + I - Underline:
Ctrl + U - Open Format Cells dialog:
Ctrl + 1 - Fill Down:
Ctrl + D - Fill Right:
Ctrl + R - Insert current date:
Ctrl + ; - Insert current time:
Ctrl + Shift + ; - Wrap text:
Alt + Enter - AutoSum (Sum of selected cells):
Alt + = - Hide selected rows or columns:
Ctrl + 9(for rows),Ctrl + 0(for columns) - Show hidden rows or columns:
Ctrl + Shift + ((for rows),Ctrl + Shift + )(for columns)
Formulas and Functions:
- Insert a function:
Shift + F3 - AutoCalculate (sum, average, etc.):
Alt + = - Edit a cell's formula:
F2 - Evaluate a formula:
Alt + M, V, Enter(step through formula evaluation) - Absolute cell reference (
$A$1):F4 - Function arguments dialog:
Ctrl + Shift + A - Insert function (new formula):
Shift + F3 - Name Manager:
Ctrl + F3
Data Management:
- Sort ascending:
Alt + A, S, A - Sort descending:
Alt + A, S, D - Filter:
Ctrl + Shift + L - Remove filter:
Alt + A, C - Data validation:
Alt + D, L(open Data Validation dialog) - Text to Columns:
Alt + D, E, F - Find:
Ctrl + F - Replace:
Ctrl + H
Cell and Worksheet Management:
- Insert new worksheet:
Shift + F11 - Delete current worksheet:
Alt + E, L - Hide/Unhide columns or rows:
Ctrl + 8 - Group/Ungroup worksheets:
Shift + F11(group),Alt + Shift + -(ungroup)
View and Zoom:
- Zoom in:
Ctrl + Scroll uporCtrl + +(Plus key) - Zoom out:
Ctrl + Scroll downorCtrl + -(Minus key) - Full-screen mode:
Ctrl + Shift + F1 - Split worksheet:
Alt + W, S(To split or remove split)
Please note that Excel shortcuts may vary depending on the version of Excel so read carefully before answering the question.