«

»

Better Excel workbook navigation

Are you an Excel power user?

Here is a great tip to make navigation workbooks that have many worksheets much easier:

  1. Add a new worksheet to your Excel workbook.
  2. Make a list of all the worksheets in the Excel workbook.
  3. Make each item in the list a Hyperlink:
    1. Click into the first cell in the list
    2. Press Crtl+K (this will open the Insert Hyperlink dialog box)
    3. Select “Place in this Document”
    4. Link to the worksheet that matched the name you just selected

You now have a table of contents worksheet that allows you to jump to any sheet in the Excel workbook.

About Advanced Network Consulting:

For businesses in LA and OC needing network support, remember that ANC offers same day service, scheduled maintenance appointments, and emergency calls. As our client, your company’s network security is our top priority.  ANC performs routine maintenance, software updates, and system upgrades as part of your network security.  Advanced Network Consulting has been servicing clients throughout Southern California for nearly 20 years.  We’ve seen every form of viruses out there and our techs are constantly educating themselves on the latest threats and tactics.  With two offices strategically located in La Mirada to serve Southeast LA County and North Orange County, and an office in Irvine to service South Orange County, same day appointments, scheduled maintenance and remote access appointments, phone support, and emergency calls are available 7 days a week.

For a complimentary one hour evaluation, one of our techs will meet at your office to assess your security and network needs.