MS Excel Shortcut Keys PDF in English for 2024 | Free Download |

by
If you want to work fast in Microsoft Excel, then it is very important to have knowledge of keyboard shortcuts. In this post, we are going to tell you all those MS Excel shortcut keys which you can use daily while working in the Excel workbook.
 
MS Excel Shortcut Keys
A shortcut key is a combination of one or more keys, by pressing which you can perform a task quickly. In the below post, we have listed the MS Excel shortcut keys in different sections based on their functions.
 

MS Excel Shortcut Keys PDF in English for 2024 | Daily Use Excel Shortcut Keys in Hindi

Here are some important Microsoft Excel shortcut keys with their descriptions:
  • Ctrl + N: Create a new workbook.
  • Ctrl + O: Open an existing workbook.
  • Ctrl + S: Save the current workbook.
  • Ctrl + P: Open the print dialog box.
  • Ctrl + Z: Undo the last action.
  • Ctrl + Y: Redo the last action.
  • Ctrl + C: Copy the selected cells or content.
  • Ctrl + X: Cut the selected cells or content.
  • Ctrl + V: Paste the copied or cut cells or content.
  • Ctrl + A: Select the entire worksheet.
  • Ctrl + F: Open the “Find” dialog box to search for specific content.
  • Ctrl + H: Open the “Replace” dialog box to find and replace specific content.
  • Ctrl + B: Apply or remove bold formatting to the selected cells or content.
  • Ctrl + I: Apply or remove italic formatting to the selected cells or content.
  • Ctrl + U: Apply or remove underline formatting to the selected cells or content.
  • Ctrl + 1: Open the “Format Cells” dialog box.
  • Ctrl + 2: Apply or remove bold formatting to the selected cells or content.
  • Ctrl + 3: Apply or remove italic formatting to the selected cells or content.
  • Ctrl + 4: Apply or remove underlined formatting to the selected cells or content.
  • Ctrl + 5: Apply or remove strikethrough formatting to the selected cells or content.

MS Excel Shortcut Keys | Daily Use Excel Shortcut Keys in Hindi

While working in MS Excel, there are some common tasks that we have to do on a daily basis. Often we accomplish these common tasks using the mouse. Such as selecting text, searching for words in a worksheet, closing the Excel window, deleting data from a cell, etc.
  • Ctrl + 6: Show or hide objects in the workbook.
  • Ctrl + 7: Show or hide the gridlines.
  • Ctrl + 8: Toggle the display of outline symbols.
  • Ctrl + 9: Hide the selected rows.
  • Ctrl + 0: Hide the selected columns.
  • Ctrl + Shift + =: Insert a new column or row.
  • Ctrl + -: Delete the selected column or row.
  • Ctrl + Shift + L: Apply or remove a filter.
  • Ctrl + Shift + F: Open the “Format Cells” dialog box with the Font tab selected.
  • Ctrl + Shift + P: Insert a new page break.
  • Ctrl + Shift + V: Paste special.
  • Ctrl + Shift + C: Copy the cell formatting.
  • Ctrl + Shift + X: Cut the cell formatting.
  • Ctrl + Shift + F3: Create names based on row and column labels.
  • Ctrl + Shift + ~: Apply the general number format.
  • Ctrl + Shift + $: Apply the currency format.
  • Ctrl + Shift + %: Apply the percentage format.
  • Ctrl + Shift + ^: Apply the exponential number format.
  • Ctrl + Shift + #: Apply the date format.
  • Ctrl + Shift + @ –  Apply the time format.
  • Ctrl + Shift + &: Apply the border format.
  • Ctrl + Shift + _: Remove the outline border.
  • Ctrl + Shift + *: Select the current region around the active cell.

Workbook MS Excel Shortcut Key in Hindi

  • Ctrl + Shift + >: Increase the font size.
  • Ctrl + Shift + <: Decrease the font size.
  • Ctrl + Shift + }: Select the current array.
  • Ctrl + Shift + {: Edit the active cell’s formula.
  • Ctrl + Shift + !: Apply the number format with two decimal places, a thousand separator, and minus sign for negative values.
  • Ctrl + Shift + &: Add borders to the selected cells.
  • Ctrl + Shift + ~: Apply the general number format.
  • Ctrl + Shift + $: Apply the currency format.
  • Ctrl + Shift + %: Apply the percentage format.
  • Ctrl + Shift + ^: Apply the exponential number format.
  • Ctrl + Shift + #: Apply the date format.
  • Ctrl + Shift + @ – Apply the time format.
  • Ctrl + Shift + !: Apply the number format with two decimal places, a thousand separator, and minus sign for negative values.
  • Ctrl + Shift + &: Add borders to the selected cells.
  • Ctrl + Shift + _: Remove the outline border.
  • Ctrl + Shift + +: Insert cells.
  • Ctrl + Shift + -: Delete cells.
  • Ctrl + Shift + ~: Apply the default number format.
  • Ctrl + Shift + $: Apply the currency format.
  • Ctrl + Shift + %: Apply the percentage format.
  • Ctrl + Shift + ^: Apply the exponential number format.
  • Ctrl + Shift + #: Apply the date format.
  • Ctrl + Shift + @: Apply the time format.
  • Ctrl + Shift + !: Apply the number format with two decimal places, a thousand separator, and minus sign for negative values.
  • Ctrl + Shift + &: Add borders to the selected cells.
  • Ctrl + Shift + _: Remove the outline border.
  • Ctrl + Shift + *: Select the current region.
  • Ctrl + Shift + <: Decrease the font size.
  • Ctrl + Shift + >: Increase the font size.
  • Ctrl + Shift + { or }: Expand or collapse the selection.
  • Ctrl + Shift + #: Apply the number format with the date format.
  • Ctrl + Shift + “: Copy the value from the cell above the active cell into the cell or the formula bar.
  • Ctrl + Shift + “: Copy the formula from the cell above the active cell into the cell or the formula bar.
  • Ctrl + Shift + T: Create a table.
  • Ctrl + Shift + F12: Save the workbook.
  • Ctrl + Shift + F6: Switch to the previous workbook window.
  • Ctrl + Shift + Tab: Switch to the previous workbook tab.
  • Ctrl + Alt + V: Display the “Paste Special” dialog box.
  • Ctrl + Alt + F1: Insert a new worksheet.
  • Ctrl + Alt + F2: Save as.
  • Ctrl + Alt + F9: Calculate all worksheets in all open workbooks.
  • Ctrl + Alt + F11: Display the Microsoft Visual Basic for the Applications editor.
  • Ctrl + Alt + =: AutoSum selected cells.
  • Ctrl + Alt + Shift + F9: Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
  • Ctrl + Alt + Shift + F12: Save the workbook.
  • Ctrl + Alt + Shift + F3: Create a name by using the names of the row and column labels.
  • Ctrl + Alt + Shift + F6: Switch to the previous workbook window.
  • Ctrl + Alt + Shift + Tab: Switch to the previous workbook tab.
  • Ctrl + Alt + Shift + +: Insert blank cells.
  • Ctrl + Alt + Shift + -: Delete cells.
  • Ctrl + Alt + Shift + #: Apply the number format with the date format.
  • Ctrl + Alt + Shift + ~: Apply the default number format.
  • Ctrl + Alt + Shift + $: Apply the currency format.
  • Ctrl + Alt + Shift + %: Apply the percentage format.
  • Ctrl + Alt + Shift + ^: Apply the exponential number format.
  • Ctrl + Alt + Shift + &: Add borders to the selected cells.
  • Ctrl + Alt + Shift + _: Remove the outline border.
These are 100 Microsoft Excel shortcut keys.

Leave a Comment