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:
New comments are not allowed.