Basic Excel Shortcuts
1. Ctrl + N: New workbook create karein
2. Ctrl + O: Open existing workbook
3. Ctrl + S: Workbook save karein
4. Ctrl + P: Print workbook
5. Ctrl + W: Close workbook
6. Ctrl + F4: Close Excel application
7. Ctrl + Z: Undo action
8. Ctrl + Y: Redo action
9. Ctrl + C: Copy selected content
10. Ctrl + X: Cut selected content
11. Ctrl + V: Paste copied or cut content
12. Ctrl + A: Select all content in the worksheet
13. Ctrl + B: Bold text
14. Ctrl + I: Italicize text
15. Ctrl + U: Underline text
16. Ctrl + E: Turn on Flash Fill
17. Ctrl + H: Open "Find and Replace" dialog box
18. Ctrl + K: Insert hyperlink
19. Ctrl + L: Open "Create Table" dialog box
20. Ctrl + T: Create a table from selected data
Navigation Shortcuts
1. Arrow keys: Move one cell up, down, left, or right
2. Ctrl + Arrow keys: Move to the edge of data (last filled cell) in the current direction
3. Home: Move to the beginning of the row
4. Ctrl + Home: Move to the first cell (A1) of the worksheet
5. Ctrl + End: Move to the last cell with content
6. Page Up: Move one screen up
7. Page Down: Move one screen down
8. Alt + Page Up: Move one screen left
9. Alt + Page Down: Move one screen right
10. F5 or Ctrl + G: Go to a specific cell by typing the cell reference (e.g., A1)
Editing Shortcuts
1. F2: Edit the active cell
2. Delete: Delete the contents of the selected cell(s)
3. Ctrl + Delete: Delete content of the selected row (to the right)
4. Shift + Delete: Delete content of the selected column (downwards)
5. Ctrl + Shift + "+": Insert a new row or column
6. Ctrl + "-": Delete a row or column
7. Ctrl + Shift + L: Turn on or off filters
8. Ctrl + Shift + "!": Apply number format with two decimal places and a thousand
separator
Formatting Shortcuts
1. Ctrl + Shift + "$": Format cells as currency
2. Ctrl + Shift + "%": Format cells as percentage
3. Ctrl + Shift + "^": Format cells as scientific number
4. Ctrl + Shift + "#": Apply date format (e.g., MM/DD/YYYY)
5. Ctrl + 1: Open the "Format Cells" dialog box
6. Alt + E, S, V: Paste special options
7. Ctrl + Shift + F: Open the "Format Font" dialog box
8. Alt + H, O, I: Auto resize column to fit contents
9. Alt + H, O, A: Auto resize row to fit contents
Working with Data
1. Ctrl + D: Fill down (copy content from the cell above)
2. Ctrl + R: Fill right (copy content from the cell to the left)
3. Ctrl + Shift + "+": Insert a new row or column
4. Ctrl + Shift + K: Insert a new blank row
5. Alt + E, S, V: Paste special values only (without formatting)
6. Alt + A + T: Remove filter from all columns
7. Alt + A + F: Apply a filter to the selected columns
Working with Worksheets and Workbooks
1. Ctrl + Page Up: Move to the previous worksheet
2. Ctrl + Page Down: Move to the next worksheet
3. Shift + F11: Insert a new worksheet
4. Alt + E, L: Delete the current worksheet
5. Ctrl + F4: Close the current workbook
6. Ctrl + Tab: Switch between open workbooks
7. Ctrl + Shift + N: Create a new blank workbook
Formulas and Functions Shortcuts
1. Alt + "=": Automatically insert SUM function
2. Ctrl + Shift + U: Expand or collapse the formula bar
3. Ctrl + ` (grave accent): Toggle between displaying formulas and the results
4. Shift + F9: Calculate the active worksheet
5. Ctrl + Shift + F3: Define a name for the selection
Excel Ribbon and Menu Shortcuts
1. Alt: Show key tips for the Ribbon commands
2. Ctrl + F1: Show or hide the Ribbon
3. Alt + H: Open the Home tab on the Ribbon
4. Alt + N: Open the Insert tab on the Ribbon
5. Alt + P: Open the Page Layout tab
6. Alt + M: Open the Formulas tab
7. Alt + A: Open the Data tab
8. Alt + R: Open the Review tab
9. Alt + W: Open the View tab
Miscellaneous Shortcuts
1. F4: Repeat the last action
2. Ctrl + F3: Open Name Manager
3. Ctrl + Shift + F3: Create names from row or column labels
4. Ctrl + Shift + L: Add or remove filters to columns
5. Ctrl + Shift + K: Open a new worksheet
6. Ctrl + Shift + "+": Insert new cells, rows, or columns
Contents
Basic Excel Shortcuts .................................................................................................................. 1
Navigation Shortcuts .................................................................................................................. 1
Editing Shortcuts ........................................................................................................................ 1
Formatting Shortcuts.................................................................................................................. 1
Working with Data ..................................................................................................................... 2
Working with Worksheets and Workbooks .............................................................................. 2
Formulas and Functions Shortcuts ............................................................................................ 2
Excel Ribbon and Menu Shortcuts ............................................................................................ 2
Miscellaneous Shortcuts ............................................................................................................. 3
