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

Popular posts from this blog

Microsoft Word 2010 Shortcut Key in Gujarati

Microsoft Word 2010 Shortcut key in Gujarati

Multi currency entry in tally

 In Tally, handling multi-currency entries allows you to record transactions involving foreign currencies. This feature is particularly useful for businesses that deal with international transactions or have accounts in different currencies. Here's how you can enable and use multi-currency entry in Tally: **Enabling Multi-Currency Feature**: 1. Go to Gateway of Tally (Home Screen). 2. Press F11 or click on "F11: Features" from the right sidebar. 3. In the Features screen, go to "F1: Accounting Features." 4. Under "Forex and Multi-Currency," set "Enable" to "Yes." 5. Save the settings. **Configuring Currency Rates**: 1. In the Gateway of Tally, click on "Accounts Info." 2. Select "Currencies" and then "Create." 3. Enter the currency details like symbol, name, formal name, etc. 4. Specify the "Standard Rates" for the currency against your base currency (usually your local currency). 5. Save the ...