Excel Shortcuts Lecture Notes

Introduction

• Discussing 20 must-know Excel shortcuts to save time.
• Sponsored by HubSpot.
• Downloadable Excel file available in the video description.

Excel Shortcuts

1. Freezing Panes

• Shortcut: Alt + W + F + R
  • Freezes the top row for better visibility when scrolling.
  • To unfreeze, go to View > Freeze Panes > Unfreeze.

2. Navigation with Control + Arrow Keys

• Shortcuts:
  • Ctrl + Down Arrow: Move to the bottom of the data set.
  • Ctrl + Up Arrow: Move to the top.
  • Ctrl + Shift + Down Arrow: Select downwards.
  • Ctrl + Shift + Right Arrow: Select to the right.

3. Copying Data with Control + R and Control + D

• Shortcuts:
  • Ctrl + R: Copies data from the left.
  • Ctrl + D: Drags data from above down.

4. Using Drop Downs with Alt + Down Arrow

• Shortcut: Alt + Down Arrow
  • Opens dropdown menu for quick selection of previous entries.

5. Selecting Rows and Columns

• Shortcuts:
  • Shift + Space: Selects a row.
  • Ctrl + Space: Selects a column.

6. Adding and Removing Rows/Columns

• Shortcuts:
  • Ctrl + Shift + +: Adds a new row/column.
  • Ctrl + -: Removes a row/column.

7. Moving Rows

• Action: Shift + Space to select, then drag to move a row.
  • Use Ctrl + Z to undo.

8. Adding Line Breaks

• Shortcut: Alt + Enter
  • Adds a line break within the same cell.

9. Adding Comments

• Shortcut: Shift + F2
  • Opens comment box for the selected cell.

10. Go To Functionality

• Shortcut: Ctrl + G
  • Opens Go To dialog for navigating to specific cell.

11. Filling Data Automatically

• Shortcut: Ctrl + E
  • Fills in missing data automatically.

12. Summing Totals

• Shortcut: Alt + =
  • Automatically sums up a range of values.

13. Copying and Pasting Values

• Shortcuts:
  • Ctrl + Space: Selects the column.
  • Ctrl + C: Copies.
  • Ctrl + Alt + V: Opens Paste Special dialog.

14. Formatting Cells

• Shortcut: Ctrl + 1
  • Opens Format Cells dialog to change currency, font, etc.

15. Using F4 to Replicate Formatting

• Action: Press F4 to repeat the last action.

16. Find and Replace

• Shortcut: Ctrl + H
  • Replaces specific values in a dataset (e.g., correcting typos).

17. Filtering Data

• Shortcut: Right-click on a cell > Filter > Filter by Selected Cell's Value.

18. Using Slicers for Filtering

• Shortcut: Ctrl + T to convert data into a table, then insert slicers.

19. Finding the Top Units Sold

• Function: MAX for highest value, LARGE for second and third highest.

20. Viewing Formulas

• Shortcut: Ctrl + \\
  • Displays all formulas in the sheet.
  • Use Alt + T + U + T to trace precedents of a formula.

Conclusion

• Encourage viewers to explore additional resources for Excel tips and tricks.