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.

  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!

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

Leave a Reply

Your email address will not be published. Required fields are marked *