Skip to main content

Excel Short cut key

 Microsoft Excel is a powerful spreadsheet software that offers numerous shortcut keys to increase productivity and efficiency. Here are some commonly used shortcut keys with examples:


1. **Ctrl + C**: Copy selected cells or text.

   Example: Select a cell or range of cells containing data, press Ctrl + C, and then you can paste the copied data elsewhere using Ctrl + V.


2. **Ctrl + X**: Cut selected cells or text.

   Example: Similar to copying, but this will remove the selected data from its original location when pasted.


3. **Ctrl + V**: Paste copied or cut cells or text.

   Example: After copying or cutting data, move the cursor to the desired destination, and press Ctrl + V to paste the data there.


4. **Ctrl + Z**: Undo the last action.

   Example: If you made a mistake, pressing Ctrl + Z will revert the most recent action.


5. **Ctrl + Y**: Redo the last undone action.

   Example: If you've used Ctrl + Z to undo an action and want to redo it, press Ctrl + Y.


6. **Ctrl + S**: Save the current workbook.

   Example: To save your Excel file, press Ctrl + S to quickly save without using the mouse.


7. **Ctrl + N**: Create a new workbook.

   Example: To start a new Excel file, use Ctrl + N to open a fresh workbook.


8. **Ctrl + O**: Open an existing workbook.

   Example: To open a saved Excel file, press Ctrl + O and navigate to the file location.


9. **Ctrl + P**: Print the current workbook.

   Example: To print the current Excel file, press Ctrl + P to open the Print dialog.


10. **Ctrl + F**: Find data within the worksheet.

    Example: Press Ctrl + F, enter the text you want to find, and Excel will search for it within the current sheet.


11. **Ctrl + H**: Replace data within the worksheet.

    Example: Press Ctrl + H, enter the text you want to find and the text you want to replace it with, and Excel will make the replacements.


12. **Ctrl + A**: Select all data in the current worksheet.

    Example: To quickly select all data in the current sheet, press Ctrl + A.


13. **Ctrl + Shift + L**: Add or remove filters on the headers of a data range.

    Example: If you have a data table, pressing this shortcut will add or remove filters to help you sort and analyze the data more effectively.


14. **Ctrl + Arrow keys**: Move to the edge of the data region in the current direction.

    Example: When working with a large dataset, pressing Ctrl + Up arrow will take you to the topmost cell with data in the current column.


15. **Ctrl + Tab**: Switch between open workbooks.

    Example: If you have multiple Excel files open, press Ctrl + Tab to toggle between them.


These are just a few examples of the many shortcut keys available in Microsoft Excel. Using these shortcuts can save you time and make your work in Excel more efficient.

Comments