Navigate anywhere in Excel workbooks

by on
in Excel Training,Office Technology

Proficient Word users probably know about Bookmarks. Bookmarks make it easy to return to certain locations in a document without scrolling or navigating with multiple Find Next actions. You can create a bookmark in Excel with a Named Range.

For example, if you use formulas on multiple work sheets to arrive at “net profit,” name the cell containing the final number Net Profit. Then, by clicking the drop-down arrow in the Name Box (the little box to the left of the Formula Bar), you can quickly navigate there by selecting Net Profit from the list anywhere in the workbook.

Leave a Comment