Wednesday, March 26, 2025

shortcut keys for Microsoft Excel:

 Here are some commonly used shortcut keys for Microsoft Excel

 General Shortcuts

- Ctrl + N: Create a new workbook.

- Ctrl + O: Open an existing workbook.

- Ctrl + S: Save the current workbook.

- Ctrl + P: Print the current sheet.

- Ctrl + W: Close the current workbook.

- Ctrl + Z: Undo the last action.

- Ctrl + Y: Redo the last action.

- Ctrl + C: Copy selected cells.

- Ctrl + X: Cut selected cells.

- Ctrl + V: Paste copied or cut cells.

- Ctrl + A: Select all cells in the current worksheet.

- Ctrl + F: Open the Find dialog box.

- Ctrl + H: Open the Find and Replace dialog box.

- Ctrl + B: Apply or remove bold formatting.

- Ctrl + I: Apply or remove italic formatting.

- Ctrl + U: Apply or remove underline formatting.

- Ctrl + K: Insert a hyperlink.

- F2: Edit the active cell.

- F7: Check spelling in the current worksheet.

- F12: Save As the current workbook.


Navigation Shortcuts Ms Excel

- Arrow Keys: Move one cell up, down, left, or right.

- Ctrl + Arrow Keys: Move to the edge of the current data region.

- Home: Move to the beginning of the row.

- Ctrl + Home: Move to the beginning of the worksheet.

- Ctrl + End: Move to the last cell with content in the worksheet.

- age Up / Page Down: Move one screen up or down.

- Alt + Page Up / Page Down: Move one screen to the left or right.

- Ctrl + F6: Switch between open workbooks.


 Selection Shortcuts Ms Excel

- Shift + Arrow Keys: Extend the selection by one cell.

- Ctrl + Shift + Arrow Keys: Extend the selection to the last non-empty cell.

- Shift + Space: Select the entire row.

- Ctrl + Space: Select the entire column.

- Ctrl + Shift + Space: Select the entire worksheet.


 Formatting Shortcuts Ms Excel

- Ctrl + 1: Open the Format Cells dialog box.

- Ctrl + Shift + $: Apply currency format.

- **Ctrl + Shift + %**: Apply percentage format.

- Ctrl + Shift + #: Apply date format.

- Ctrl + Shift + @: Apply time format.

- Ctrl + Shift + !: Apply number format with two decimal places.


 Formula Shortcuts Ms Excel

- Alt + = : AutoSum selected cells.

- F4: Toggle between absolute and relative references in a formula.

- Ctrl + `: Show or hide formulas in the worksheet.


 Data Manipulation Shortcuts Ms Excel

- Ctrl + T: Create a table from the selected data.

-Ctrl + Shift + L: Toggle filters on or off.

- Alt + Down Arrow : Open the drop-down menu for the selected cell (if filtered).

- Ctrl + D: Fill down (copy the content of the topmost cell to the selected cells below).

- Ctrl + R: Fill right (copy the content of the leftmost cell to the selected cells to the right).

- Ctrl + ;: Insert the current date.

- Ctrl + Shift + ;: Insert the current time.


These shortcuts can help you work more efficiently in Excel. Let me know if you need more advanced shortcuts or specific tasks!

No comments: