MS Excel Shortcuts (2)
Vishal Sharrma
Thought Leader | SIAM Consultantancy | Expert in Different Auxiliaries of Service Management | Client Satisfaction Champion | Leader in Driving Service Excellence and Process Optimization | Center of Excellence
Here are 10 more useful Excel shortcuts
Data Manipulation
Ctrl + Shift + L: Filter data based on criteria.
Ctrl + Shift + &: Apply AutoSum to sum adjacent cells.
Alt + H, D, C: Delete the selected column.
Ctrl + T: Convert a range of cells into a formatted table.
Ctrl + F: Open the Find and Replace dialog box.
Formatting and Appearance
Ctrl + 1: Format cells as Number.
Ctrl + Shift + 4: Format cells as Currency.
Ctrl + Shift + %: Apply percentage formatting.
Alt + H, B, A: Add borders to selected cells.
Ctrl + Shift + F: Open the Format Cells dialog box for advanced formatting.
Bonus
Ctrl + Enter instead of Enter to move to the next cell in a data entry form.
F4: Repeat the last action (e.g., formatting, pasting).
Ctrl + PgUp/PgDn: Move between worksheets quickly.
F5: Go to a specific cell or named range.
Ctrl + ` (backtick): Toggle between showing cell formulas and their calculated values.