Want to know the shortcut keys of MS Excel? Don’t worry here I will provide you with 50 shortcut keys of MS Excel that can help you to use MS Excel easily.
MS Excel is a powerful spreadsheet software that has become a staple tool in the world of finance and business. As with any software, mastering keyboard shortcuts can greatly improve your efficiency and productivity.
I know it can be difficult for you to learn over 50 keyboard shortcut keys at once. But, if you give yourself time to learn these shortcuts keys can save you time and make your work faster and more efficient.
Let’s explore 50 shortcut keys of MS Excel, categorized by their respective functions, to help you become a power user in no time. Whether you are an experienced Excel user or a beginner, these shortcuts will help you navigate and work with Excel more easily and quickly.
50 shortcut keys of MS Excel
Here are 50 Shortcut Keys of MS Excel, along with meanings and examples:
- Ctrl + N: Create a new workbook
Example: Pressing Ctrl + N will create a new, blank workbook.
- Ctrl + O: Open an existing workbook
Example: Pressing Ctrl + O will open the “Open” dialog box, allowing you to select an existing workbook to open.
- Ctrl + S: Save the current workbook
Example: Pressing Ctrl + S will save the current workbook to its current location.
- Ctrl + P: Print the current worksheet
Example: Pressing Ctrl + P will open the “Print” dialog box, allowing you to select a printer and print options.
- Ctrl + Z: Undo the last action
Example: Pressing Ctrl + Z will undo the last action taken in the workbook.
- Ctrl + Y: Redo the last action
Example: Pressing Ctrl + Y will redo the last action that was undone with Ctrl + Z.
- Ctrl + X: Cut the selected cells
Example: Select a range of cells and press Ctrl + X to cut the cells.
- Ctrl + C: Copy the selected cells
Example: Select a range of cells and press Ctrl + C to copy the cells.
- Ctrl + V: Paste the copied or cut cells
Example: Press Ctrl + V to paste the cells that were previously copied or cut.
- Ctrl + F: Find text or value in the worksheet
Example: Press Ctrl + F to open the “Find and Replace” dialog box and search for specific text or values in the worksheet.
- Ctrl + H: Replace text or value in the worksheet
Example: Press Ctrl + H to open the “Find and Replace” dialog box and replace specific text or values in the worksheet.
- Ctrl + A: Select the entire worksheet
Example: Pressing Ctrl + A will select all cells in the current worksheet.
- Ctrl + B: Bold selected text or value
Example: Select text or values and press Ctrl + B to make the text or value bold.
- Ctrl + I: Italicize selected text or value
Example: Select text or values and press Ctrl + I to make the text or value italicized.
- Ctrl + U: Underline selected text or value
Example: Select text or values and press Ctrl + U to make the text or value underlined.
- Ctrl + 1: Open the “Format Cells” dialog box
Example: Press Ctrl + 1 to open the “Format Cells” dialog box, which allows you to change cell formatting.
- Ctrl + ;: Insert the current date
Example: Press Ctrl + ; to insert the current date in the active cell.
- Ctrl + Shift + #: Apply the time format
Example: Select a range of cells containing time data and press Ctrl + Shift + # to apply the time format.
- Ctrl + Shift + $: Apply the currency format
Example: Select a range of cells containing currency data and press Ctrl + Shift + $ to apply the currency format.
- Ctrl + Shift + %: Apply the percentage format
Example: Select a range of cells containing percentage data and press Ctrl + Shift + % to apply the percentage format.
- Ctrl + Shift + &: Apply a border to selected cells
Example: Select a range of cells and press Ctrl + Shift + & to apply a border to the cells.
- Ctrl + Shift + #: Apply the date format
Example: Select a range of cells containing date data and press Ctrl + Shift + # to apply the date format.
- Ctrl + Shift + !: Apply the comma format
Example: Select a range of cells containing numeric data and
- Ctrl + Shift + ~: Apply the general format
Example: Select a range of cells containing various types of data and press Ctrl + Shift + ~ to apply the general format, which displays data as is without any formatting.
- Ctrl + Shift + ^: Apply the exponent format
Example: Select a range of cells containing numeric data and press Ctrl + Shift + ^ to apply the exponent format, which displays numbers in scientific notation.
- Ctrl + Shift + *: Select the current region
Example: Press Ctrl + Shift + * to select the current region, which is the contiguous range of cells that contain data and is bounded by blank rows or columns.
- Ctrl + Home: Go to the beginning of the worksheet
Example: Press Ctrl + Home to go to cell A1, the beginning of the worksheet.
- Ctrl + End: Go to the last cell containing data in the worksheet
Example: Press Ctrl + End to go to the last cell containing data in the worksheet.
- Ctrl + Page Up: Go to the previous worksheet
Example: Press Ctrl + Page Up to go to the previous worksheet in the workbook.
- Ctrl + Page Down: Go to the next worksheet
Example: Press Ctrl + Page Down to go to the next worksheet in the workbook.
- Ctrl + Tab: Switch to the next workbook window
Example: If you have multiple workbooks open, press Ctrl + Tab to switch to the next workbook window.
- Ctrl + Shift + Tab: Switch to the previous workbook window
Example: If you have multiple workbooks open, press Ctrl + Shift + Tab to switch to the previous workbook window.
- Alt + =: Insert the SUM function
Example: Select a range of cells and press Alt + = to insert the SUM function, which adds up the values in the selected cells.
- F2: Edit the active cell
Example: Double-click on a cell or select a cell and press F2 to enter edit mode, which allows you to edit the cell contents.
- F4: Repeat the last action
Example: Press F4 to repeat the last action taken in the worksheet.
- F5: Go to a specific cell
Example: Press F5 to open the “Go To” dialog box, which allows you to go to a specific cell or named range.
- F7: Open the spell checker
Example: Press F7 to open the spell checker, which checks the spelling of text in the worksheet.
- F9: Calculate the active worksheet
Example: Press F9 to calculate the active worksheet, which updates any formulas or functions that are dependent on cell values.
- F11: Create a chart from the selected data
Example: Select a range of cells containing data and press F11 to create a chart based on the selected data.
- Shift + F3: Insert a function
Example: Press Shift + F3 to open the “Insert Function” dialog box, which allows you to select and insert a function into a cell.
- Shift + F5: Go to the last edited cell
Example: Press Shift + F5 to go to the last edited cell in the worksheet.
- Shift + F11: Insert a new worksheet
Example: Press Shift + F11 to insert a new worksheet into the workbook.
- Shift + F12: Save the workbook
Example: Press Shift + F12 to save the workbook with its current file name.
- Ctrl + Shift + F3: Create names from row and column labels
Example: Select a range of cells containing row and column labels and press Ctrl + Shift + F3 to create names for the labels.
- Ctrl + Alt + V: Paste special
Example: Copy a range of cells and press Ctrl + Alt + V to open the “Paste Special” dialog box, which allows you to choose how to paste the copied cells.
- Ctrl + Shift + L: Toggle the filter
Example: Select a range of cells containing data and press Ctrl + Shift + L to toggle the filter, which allows you to filter and sort the data based on specific criteria.
- Ctrl + 1: Open the “Format Cells” dialog box
Example: Select a range of cells and press Ctrl + 1 to open the “Format Cells” dialog box, which allows you to format the cells in various ways.
- Ctrl + Shift + $: Apply the currency format
Example: Select a range of cells containing numeric data and press Ctrl + Shift + $ to apply the currency format, which displays numbers with a currency symbol and decimal places.
- Ctrl + Shift + #: Apply the date format
Example: Select a range of cells containing date data and press Ctrl + Shift + # to apply the date format, which displays dates in the default format for your region.
Conclusion (50 Shortcut Keys Of MS Excel)
In this blog, we have discussed 50 Shortcut keys of MS Excel. I hope you have understood easily. Shortcut keys are a very important aspect of using Microsoft Excel efficiently and effectively. By memorizing and utilizing the various shortcuts available, you can save time and effort in performing common tasks, and become a more proficient and productive Excel user.
The shortcut keys listed above provide just a small sampling of many shortcuts available, and by exploring and experimenting with different combinations, you can find even more ways to streamline your Excel workflow. To get help with Microsoft Excel, you can contact our experts who can help you with Excel.