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

Post a Comment

Popular posts from this blog

Microsoft Word 2010 Shortcut Key in Gujarati

Microsoft Word 2010 Shortcut key in Gujarati
16 comments
Read more

Power Point Shortcut key

Below is a list of common PowerPoint shortcut keys along with their details: 1. New Presentation: Ctrl + N    - Creates a new, blank PowerPoint presentation. 2. Open Presentation: Ctrl + O    - Opens an existing PowerPoint presentation from your computer. 3. Save Presentation: Ctrl + S    - Saves the current presentation to its existing file location. 4. Save As: F12    - Opens the "Save As" dialog box to save the current presentation with a new name or at a different location. 5. Close Presentation: Ctrl + W    - Closes the current presentation. 6. Cut: Ctrl + X    - Cuts the selected content (text, images, etc.) and places it on the clipboard for pasting. 7. Copy: Ctrl + C    - Copies the selected content (text, images, etc.) to the clipboard for duplication. 8. Paste: Ctrl + V    - Pastes the content from the clipboard into the presentation. 9. Undo: Ctrl + Z    - Reverses the last action perfor...
Post a Comment
Read more

SQL Cheat Sheet

SQL cheat sheet with explanations for each command: 1. SELECT: Retrieve data from a database table.    Example: `SELECT column1, column2 FROM table_name;` 2. DISTINCT: Remove duplicate rows from the result set.    Example: `SELECT DISTINCT column FROM table_name;` 3. WHERE: Filter rows based on specific conditions.    Example: `SELECT * FROM table_name WHERE column = value;` 4. AND / OR: Combine multiple conditions in a WHERE clause.    Example: `SELECT * FROM table_name WHERE condition1 AND condition2;` 5. ORDER BY: Sort the result set based on one or more columns.    Example: `SELECT * FROM table_name ORDER BY column ASC;` 6. GROUP BY: Group rows based on specified columns (usually used with aggregate functions).    Example: `SELECT column, COUNT(*) FROM table_name GROUP BY column;` 7. HAVING: Filter groups of rows based on aggregate function results.    Example: `SELECT column, COUNT(*) FROM table_name GROUP BY col...
Post a Comment
Read more