Prior to Excel 2007, you were able to create custom views and place the Custom View icon on the menu bar and a down arrow appeared to the right of the icon.  This allowed users to select the view that wascreated for their particular viewing.  It was a quick way to navigate to a particular part of the spreadsheet.  Unfortunately, this method is no longer available.  Instead, you create the views as before but to go to one of the views, you now click on the View tab, select Custom Views, choose a View, and then click on Show.

This method has too many steps; therefore, I created hyperlinks to do the same job but on with one click. Here are the steps:

  1. Name the highlighted range that you want the user to go to.
  2. In an empty sheet, I call it the “Menu”sheet.  Design it in order to direct the user to go to a range on found in another sheet or to a specific sheet.
  3. Choose Insert and select the Hyperlink option (or Control+K) to open the Insert Hyperlink dialog box.
  4. Click the Place In This Document icon on the left.
  5. You can Choose three ways:
    1. choose the range name under the Define Names
    2. choose a sheet name
    3. choose a sheet name with a specific cell location
  6. Click OK to create the hyperlink.
Advertisements