This is, hands down, one of the most useful shortcuts in Microsoft Excel because no matter what industry you’re in or what kind of project you’re working on, you will have to move between the sheets countless times.
In this video, I’m going to show you how to fly effortlessly from one tab (worksheet) to another with Jedi-like precision.
Download FREE Hands-On Exercises
Full Video Transcript:
This is, hands down, one of the most useful shortcuts in Microsoft Excel because no matter what industry you’re in or what kind of project you’re working on, you will have to move between the sheets countless times. And today, I’m going to show you how to fly effortlessly from one sheet to another with Jedi-like precision.
Instead of clicking with the mouse to go back and forth between your worksheets, we’re now going to use the keyboard. On the PC, you’re going to hit CTRL + PGDN to go to the right, you’re going to hit CTRL + PGUP to go to the left, right? So CTRL + PGDN is the next, or to the right, CTRL + PGUP is previous, or to the left.
Same deal on the Mac, it’s CTRL + PGUP / CTRL + PGDN but to get to those keys, you have to hit the FN + DOWN or FN + UP. But again, it’s the same concept, PGUP/PGDN.
That leads us to the most amazing memory trick ever, at least I think so. Control your pages before they wet all the sheets. So, think of pages as like rambunctious little kids that are going around peeing everywhere. It’s gross, but it’ll help you remember, hopefully. That’s the way to remember it. Control your pages before they wet all the sheets.
In this exercise, I created a specific exercise to practice this over and over again. From the start point, you’re going to move all the X’s. You’re going to go to the cell that has the first X, CTRL + X on a PC or COMMAND + X on the Mac to cut it. You’re going to move over with your CTRL + PGDN until you get to the right spot, and CTRL + V to paste. You’re going to keep going back and forth until you could do this for all of the X’s. That’s your exercise.
Don’t forget to visit test.excelshir.com where you can download these exercises, along with other free resources such as keyboard shortcut cheat sheets for both PC and Mac.
Thanks for watching. See you next time, and one quick thing before you go. I was texting Chewbacca the other day and he was telling me how he was trying to fix the Millennium Falcon, the Hyperdrive wasn’t working. I said, “Listen, Chewie. Just share the Excel love. It’ll all work out.”