MS Excel Shortcuts (3)
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
Formula and Functions
F4: Absolute cell reference toggle (e.g., $A$1).
Ctrl + Enter: Enter an array formula (useful for complex calculations).
F9: Calculate all formulas in the workbook.
Ctrl + Shift + Enter: Create a named range.
F2: Edit a formula directly in the cell.
Charting and Visualization
Alt + F1: Create a chart from selected data.
Alt + H, C, C: Change the chart type.
Ctrl + Space: Add data labels to a chart.
Ctrl + Shift + F: Format chart elements.
Alt + H, F, N: Filter data points in a chart.
Macros and Automation
Alt + F11: Open the Visual Basic Editor (VBA) for creating macros.
Ctrl + R: Record a macro to automate repetitive tasks.
F5: Run a recorded macro.
Ctrl + Break: Stop a running macro.
Alt + F8: Manage and run existing macros.
More
Ctrl + Shift + K: Create a hyperlink to a website or file.
Ctrl + Enter in the formula bar to confirm a formula and return to the cell.
F12: Save As.
Ctrl + P: Print the active worksheet.
Ctrl + H: Find and Replace text and values.