Study Smart, Not Hard. - StudyMuch

Microsoft Excel Shortcut Keys

Published by StudyMuch on

Microsoft Excel Shortcut Keys

Microsoft Excel Shortcut Keys

Microsoft Excel has long been a staple tool for professionals and students alike when it comes to managing data, performing calculations, and creating insightful visualizations. While the software offers a wide range of features, it’s the keyboard shortcuts that can really unleash your productivity potential. In this blog post, we elaborate on the top 50 Microsoft Excel Shortcut Keys, which empower you to navigate the application with ease and efficiency.

Top 50 Microsoft Excel Shortcut Keys

Ctrl+C: Copy selected cells.

Ctrl+V: Paste copied cells.

Ctrl+X: Cut selected cells.

Ctrl+S: Save the current workbook.

Ctrl+Z: Undo the last action.

Ctrl+Y: Redo the last action.

Ctrl+B: Apply or remove bold formatting.

Ctrl+I: Apply or remove italic formatting.

Ctrl+U: Apply or remove underline formatting.

Microsoft Excel Shortcut Keys

Ctrl+P: Print the current workbook.

Ctrl+A: Select the entire worksheet.

Ctrl+F: Open the “Find and Replace” dialog box.

Ctrl+H: Open the “Find and Replace” dialog box with the “Replace” tab selected.

Ctrl+K: Insert a hyperlink.

Ctrl+N: Create a new workbook.

Ctrl+O: Open an existing workbook.

Ctrl+T: Create a new table.

Ctrl+W: Close the current workbook.

Ctrl+Shift+L: Apply or remove filters.

Ctrl+Shift+P: Insert the current date.

Ctrl+Shift+;: Insert the current time.

Ctrl+Shift+1: Apply the number format.

Ctrl+Shift+~: Apply the general format.

Ctrl+Shift+$: Apply the currency format.

Ctrl+Shift+%: Apply the percentage format.

Ctrl+Shift+#: Apply the date format.

Ctrl+Shift+!: Apply the time format.

Ctrl+Shift+@: Apply the time format with the hour and minute.

Ctrl+Shift+^: Apply the exponential number format.

Ctrl+Shift+*: Select the current region around the active cell.

Ctrl+Shift+( or ): Unhide hidden rows or columns.

Ctrl+Shift+&: Apply an outline border to selected cells.

Ctrl+Shift+_ (underscore): Remove an outline border.

Ctrl+Shift+<: Decrease the font size.

Ctrl+Shift+>: Increase the font size.

Ctrl+Shift+!: Format the selected cells as number format with two decimal places.

Ctrl+Shift+1: Apply the comma format.

Ctrl+Shift+2: Apply the time format with the hour and minute.

Ctrl+Shift+3: Apply the date format with the day, month, and year.

Ctrl+Shift+4: Apply the currency format with two decimal places.

Ctrl+Shift+5: Apply the percentage format with no decimal places.

Ctrl+Shift+6: Apply the exponential number format with two decimal places.

Ctrl+Shift+F3: Create a name using the names of non-empty cells.

Ctrl+Shift+F6: Switch between open workbooks.

Ctrl+Shift+F9: Calculate all worksheets in all open workbooks.

Ctrl+Shift+F10: Display the shortcut menu for a selected item.

Ctrl+Shift+F11: Create a new worksheet.

Ctrl+Shift+F12: Open the “Save As” dialog box.

Ctrl+Page Up: Switch between worksheets from left to right.

Ctrl+Page Down: Switch between worksheets from right to left.


Mastering the shortcut keys of Microsoft Excel can significantly increase your productivity and efficiency when working with spreadsheets. With these top 50 shortcuts, you can easily navigate through Excel’s features, saving you time and effort in your data management tasks. Whether you’re copying and pasting data, applying formatting, or performing calculations, these shortcuts will streamline your workflow and make you a power user of Excel.

Remember, practice makes perfect! Take the time to become familiar with these shortcuts and incorporate them into your daily Excel use. Soon, you’ll find yourself working effortlessly through workbooks, performing complex tasks, and impressing coworkers with your efficiency.

So, start using these shortcut keys and unlock the full potential of Microsoft Excel.

Learn More;


Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *