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.
- Tip Card: Business Management Daily's Favorite Keyboard Shortcuts
- Excel: Find peace with merged cells and calculations--two natural enemies
- Subtotaling manually in Excel? You should know about the Subtotal tool
- When should I use VLookUp? When is it better to use Index and Match?
- Microsoft Office Notes: May '16