From the course: Excel Quick Tips

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Create and use bookmarks in Excel

Create and use bookmarks in Excel - Microsoft Excel Tutorial

From the course: Excel Quick Tips

Start my 1-month free trial Buy for my team

Create and use bookmarks in Excel

“

- [Instructor] Large workbooks in Excel can be a pain to navigate through. In Excel, you can bookmark key locations in your workbook. Simply click on a cell. In the bar at the top left, you will see a name box right here. So let's call this one Sales_By_month, press Enter. And then I will scroll down in my worksheet. And here I have my sales by quarter. I'm going to select the cell A32. And once again, I will just go in the name box here and call this Sales_By_Quarter, press Enter. And now, when I click on the arrow right here, I can navigate to my Sales_By_month. And if I click again, Sales_By_Quarter. And I can name any sale like this.

Contents