From the course: Excel: Productivity Tips

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Navigating workbooks with CTRL shortcuts

Navigating workbooks with CTRL shortcuts - Microsoft Excel Tutorial

From the course: Excel: Productivity Tips

Start my 1-month free trial

Navigating workbooks with CTRL shortcuts

“

- [Instructor] All right, time to talk about quickly and efficiently navigating through worksheets using CTRL shortcuts. This is another one of our very basic one-star productivity tips, but that doesn't mean it's not valuable and important. In fact, these simple CTRL shortcuts can save you a huge amount of time in the long run. Now, I'm not going to talk through every single shortcut option that Excel has to offer. Instead, I'm going to share with you the ones that I tend to use most frequently. So here are a few of my favorites. Let's start with CTRL + arrow, those up down, left, right arrows on your keyboard. What those will do is jump to the edge of a contiguous range of cells. That means a range with no blanks in between. And if you're on a Mac, you're going to use CMD + arrow for the shortcut. And at the same time, you can hold shift and not just jump to the last cell, but also create a selection at the same time.…

Contents