Ditch the Mouse
Giving up my mouse seems so daunting. Where do I even start? We break down ditching the mouse into two main areas - navigation and formatting.
Why should we care about Ditching the Mouse when working in spreadsheets?
Great question. In a nutshell, increased speed and better accuracy.
Not going back and forth between the keyboard and your mouse will increase your speed, resulting in time savings. Time saved = less time buried in spreadsheets and more time to do other things!
It also enables you to be more accurate when selecting data -- particularly when working with large sets of data. You can save time and be more confident in your analysis.
Ditch The Mouse Session March 2023 (YouTube)
Giving up my mouse seems so daunting. Where do I even start?
We break down ditching the mouse into two main areas -- navigation and formatting -- with easy-to-follow steps so you don't have to tackle it all at once (although you can!). We've included some of the highlights below -- watch the full video for a comprehensive overview. You can also review to the specific sections in the full video as outlined below.
| Topic | Time Stamp |
|---|---|
| Navigation: Within the worksheet | 3:27 - 18:45 |
| Navigation: Within the cell | 18:49 - 32:23 |
| Formatting: Master shortcuts | 32:48 - 36:47 |
| Formatting: Paste special | 36:49 - 42:52 |
Navigating without the mouse
Learning to navigate around the worksheet without the mouse is all about getting repetitive practice and working that muscle memory and intuition.
Navigating within the worksheet -- At a glance
- Move from cell to cell: Arrow keys
- Jump across blocks of text: Ctrl (PC) / Cmd (Mac)
- Select cells: Shift + Arrow keys
- Jump + Select cells together: Ctrl/Cmd + Shift + Arrow keys
The basics -- move, jump, select, and jump+select using keyboard shortcuts.
Copying and Pasting across datasets -- use keyboard navigation to efficiently copy data between areas.
Copying 50 rows of data without the mouse! -- demonstrates selecting large datasets using only keyboard shortcuts.
Additional practice: Mazes! -- Navigate to the Maze tab and jump into some maze exercises. What's your personal best?
Navigating within a cell -- At a glance
Quick tip: Turn on your F keys whenever you're working in spreadsheets.
Editing text or a formula in a cell: F2
Editing text -- When we navigate to a cell in our spreadsheet (using our arrow keys) and hit F2, we are then able to edit the contents of that cell. Once inside, we can use our arrow keys to move around.
Tip: We can also use home/end to navigate to the beginning or end of the cell's contents respectively, and our jumping keys (Ctrl (PC) and Cmd (Mac) + Arrow keys) to jump left or right.
Editing a formula -- We edit a formula the same way as text (hitting F2 in the cell with the formula), but things get a bit complicated when you need to add or edit cell references to an existing formula.
Formatting without the mouse
Formatting in Excel and Google Sheets without the mouse really comes down to effectively leveraging shortcuts and the paste special function.
Master Shortcuts -- At a glance
Use master shortcuts wherever possible to reduce the number of individual shortcuts you need to memorize.
Master Shortcuts:
- Excel: Ctrl +1 (PC) or Cmd + 1 (Mac)
- PC Excel Ribbon shortcuts: Alt
- Google Sheets: Alt + / (PC) or Option + / (Mac)
Paste Special -- At a glance
Minimize rework and use existing formatting wherever possible. Use your paste special shortcuts to copy existing formatting and column widths without affecting formulas or values.
- Excel: Alt + E + S (PC), Cmd + Ctrl + V (Mac)
- Sheets: Use your search master shortcuts (Alt + / , Option + /)