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

1BHK & 2BHK in BHUJ More Detail - Ahesan Sumra - 98796 87217

 

About all version of tally

 Tally is a popular accounting software developed by Tally Solutions Pvt. Ltd. It is widely used for accounting, financial management, inventory management, and taxation purposes. As of my knowledge cutoff in September 2021, here are some of the major versions of Tally: 1. **Tally 4.5**: This was one of the early versions of Tally released in the 1990s. It offered basic accounting features and was primarily used for simple bookkeeping tasks. 2. **Tally 5.4**: Released in the late 1990s, Tally 5.4 introduced several improvements and additional functionalities to cater to the evolving needs of businesses. 3. **Tally 6.3**: This version brought significant enhancements to Tally's capabilities, including support for Value Added Tax (VAT) and various other statutory requirements. 4. **Tally 7.2**: Launched in 2005, Tally 7.2 further expanded Tally's features, making it more robust and user-friendly. It introduced support for multiple currencies and multiple companies. 5. **Tally 8.1...