excel-feature

How To Quickly Navigate In Excel

Say you have a large Excel Worksheet and you need to be able to quickly access rows that are buried way down. Fortunately, there is a built-in method to accomplish this task.

Follow the steps below to learn how:

  1. Press F5 which will display the Go to dialog.

f5

  1. Click OK.

What about named ranges?  Well, I am glad you asked. F5 works just as well with a named range. Simply enter the range name instead of a reference. Excel will select the entire range for you!

Scroll to Top

WHY NOT SUBSCRIBE TO OUR NEWSLETTER?

Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!