100 Professional MS Excel Shortcuts to Boost Your Productivity
Microsoft Excel is an indispensable tool for professionals across various industries. Whether you’re managing data, creating reports, or analyzing complex information, mastering Excel keyboard shortcuts can significantly boost your productivity and efficiency. In this guide, we will explore 100 professional Excel shortcuts that every user should know to enhance their workflow and work smarter, not harder.
Why MS Excel Shortcuts Are Crucial
Efficiency is key when working with Excel. Utilizing keyboard shortcuts helps users save valuable time and reduces the risk of repetitive strain injuries from excessive mouse use. By incorporating these shortcuts into your daily Excel tasks, you can speed up data entry, formatting, and calculations, while focusing on the most important aspects of your work.
The Ultimate List of 100 Professional MS Excel Shortcuts
Here is a comprehensive list of Excel shortcuts that will make your work much faster and more efficient:
Basic Excel Shortcuts
- Ctrl + N – Open a new workbook.
- Ctrl + O – Open an existing workbook.
- Ctrl + S – Save the current workbook.
- Ctrl + P – Print the current worksheet.
- Ctrl + F – Open the Find and Replace dialog box.
- Ctrl + H – Replace text in the worksheet.
- Ctrl + Z – Undo the last action.
- Ctrl + Y – Redo the last undone action.
- Ctrl + W – Close the current workbook.
- Ctrl + F12 – Open the Open dialog box.
- Ctrl + P – Print the worksheet.
- Ctrl + Q – Display the Quick Analysis tools.
Navigation Shortcuts
- Ctrl + Arrow Key – Jump to the edge of data regions.
- Home – Move to the beginning of a row.
- Ctrl + Home – Move to the beginning of the worksheet (A1).
- Ctrl + End – Jump to the last cell of the worksheet.
- Page Up – Scroll up one screen.
- Page Down – Scroll down one screen.
- Ctrl + G – Go to a specific cell.
- Ctrl + Shift + G – Go to a specific range or named range.
- Alt + Page Up – Scroll left one screen.
- Alt + Page Down – Scroll right one screen.
Selection Shortcuts
- Ctrl + Shift + Arrow Key – Select a range of cells.
- Shift + Space – Select the entire row.
- Ctrl + Space – Select the entire column.
- Ctrl + A – Select all cells in the worksheet.
- Ctrl + Shift + L – Toggle filters on and off.
- Ctrl + Shift + Space – Select the entire worksheet.
- Ctrl + Shift + 9 – Unhide hidden rows.
- Ctrl + Shift + 0 – Unhide hidden columns.
- Shift + F8 – Add to the selection of cells.
- Alt + ; – Select visible cells only (useful when filtering data).
Formatting Shortcuts
- Ctrl + B – Bold the selected text.
- Ctrl + I – Italicize the selected text.
- Ctrl + U – Underline the selected text.
- Ctrl + 1 – Open the Format Cells dialog box.
- Ctrl + Shift + $ – Format as currency.
- Ctrl + Shift + % – Format as percentage.
- Ctrl + Shift + ! – Apply number formatting with two decimal places.
- Ctrl + E – Activate Flash Fill.
- Ctrl + Shift + & – Apply a border to the selected range.
- Ctrl + Shift + _ – Remove borders from the selected range.
- Ctrl + Shift + ” (quote) – Copy the value from the cell above.
- Ctrl + Shift + # – Format the number as a date.
- Ctrl + Shift + @ – Format the number as time.
Data Management Shortcuts
- Ctrl + C – Copy the selected cells.
- Ctrl + X – Cut the selected cells.
- Ctrl + V – Paste the copied or cut cells.
- Ctrl + Shift + V – Paste special options.
- Ctrl + D – Fill down from the cell above.
- Ctrl + R – Fill right from the cell on the left.
- Alt + E, S, T – Paste values and transpose.
- Ctrl + T – Convert the selected range into a table.
- Ctrl + Shift + L – Toggle the AutoFilter feature.
- Ctrl + F3 – Open the Name Manager.
- Ctrl + Shift + “+” – Insert a row or column.
- Ctrl + Shift + ” (quote) – Copy data from the cell above.
- Alt + E, S, V – Open the paste special dialog box.
Formulas and Calculations
- Alt + = – AutoSum selected range.
- F2 – Edit the active cell.
- Ctrl + Shift + Enter – Enter an array formula.
- Ctrl + ` – Toggle the formula view in the worksheet.
- Ctrl + Shift + T – Insert the current date.
- Ctrl + Shift + F3 – Open the Define Names dialog box.
- Alt + M + M – Display the Insert Function dialog box.
- Ctrl + Shift + U – Expand the formula bar.
- Ctrl + Shift + ~ – Toggle between displaying formulas and results.
- Ctrl + Shift + C – Copy the formula from the selected cell.
- Ctrl + ` (backtick) – Toggle between the normal view and formula view.
Advanced Excel Shortcuts
- Ctrl + F9 – Minimize the workbook window.
- Ctrl + F10 – Maximize or restore the workbook window.
- Ctrl + F11 – Insert a new worksheet.
- Alt + F11 – Open the Visual Basic for Applications (VBA) editor.
- Ctrl + Shift + F12 – Open the Print dialog box.
- Ctrl + Shift + K – Insert a hyperlink.
- Ctrl + Alt + F9 – Calculate all worksheets in all open workbooks.
- F9 – Calculate the active worksheet.
- Ctrl + Alt + V – Paste values only.
- Alt + D + P – Open the PivotTable wizard.
- Alt + Shift + Right Arrow – Group data in a PivotTable.
- Alt + Shift + Left Arrow – Ungroup data in a PivotTable.
- Ctrl + Shift + F4 – Repeat the last find action.
Pivot Table Shortcuts
- Alt + N + V – Insert a PivotTable.
- Alt + Shift + Down Arrow – Expand the selected group in a PivotTable.
- Alt + Shift + Up Arrow – Collapse the selected group in a PivotTable.
- Ctrl + Alt + F5 – Refresh all PivotTables.
- Ctrl + Shift + L – Toggle PivotTable filters on/off.
Chart Shortcuts
- F11 – Create a chart with the selected data.
- Ctrl + Shift + C – Copy chart formatting.
- Ctrl + Shift + V – Paste chart formatting.
- Alt + F1 – Create an embedded chart.
- Ctrl + Shift + T – Insert a table.
- Ctrl + Arrow Up/Down – Navigate through chart data.
Miscellaneous Excel Shortcuts
- Ctrl + F4 – Close the current workbook.
- Ctrl + Tab – Switch between open workbooks.
- Alt + F8 – Open the Macro dialog box.
- F7 – Open the Spelling dialog box.
- Shift + F3 – Insert a function into the active cell.
- Ctrl + Shift + F12 – Open the Print dialog box.
- Alt + F4 – Close the Excel application.
