Wednesday, November 21, 2018

Quick tip: Quickly navigate multiple Excel worksheets, much like a table of contents

I recently did an AXUG Session about using the real time integration to Excel. You can build all sorts of reports/metrics and have the data auto-refresh when opening the form.

Its great! And you can really fill up an Excel worksheet quickly...  But for those that really get into it, traversing a massive Excel sheet can get pretty daunting. The resolution to this for some people is to create other Excel files in a static location that all reference each other. That works, and is ok for some purposes, but not always. I would NOT recommend breaking out an Excel sheet into multiple linked Excel sheets just for ease of navigation sake. Once you hit the 4th or 5th linked Excel file and have more than one person trying to figure it out, good luck.

An alternative approach
A little known trick to quickly navigate multiple Excel worksheets, much like a table of contents, is to right click on the arrows in the lower left hand side of the application (to the left of the worksheet tabs). This will open a form called 'Activate'. 'Activating' a worksheet just means that it will be navigated to. Its not really activating or enabling anything. The terminology is a little odd but thats all its saying. This is basically a table of contents for your Excel file!

I had a worksheet with over 50 tabs and could navigate to a specific one in three clicks (right click on arrows, select worksheet, click ok). You might need to scroll to the worksheet if there are a lot but thats easier than the alternatives or a table of contents workbook tab.

Hope that helps!


Figure 1 - The many, long worded Excel worksheets

Figure 2 - Right click on the arrows to see all worksheets

12 comments:

  1. If you have short time and want to appear in MCSA SQL Server 2016 Database Development Exam. Then I will suggest you to use MCSA SQL Server 2016 Database Development Dumps. I have aced my exam with guaranteed results with MCSA: SQL 2016 Database Development Dumps. I simply practice all the questions and found almost same questions in the final test. I am thankful to vceexamstest.com for carving such a handy and useful study material.

    ReplyDelete
  2. May 2019 Pass CCNP Routing and Switching 300-101 questions and answers Crack4sure
    Cisco 300-101 Exams

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Thanks for sharing
    "Sanjary Academy provides excellent training for Piping design course. Best Piping Design Training Institute in Hyderabad,
    Telangana. We have offer professional Engineering Course like Piping Design Course,QA / QC Course,document Controller
    course,pressure Vessel Design Course, Welding Inspector Course, Quality Management Course, #Safety officer course."
    Best video editing services in Hyderabad,ameerpet
    Best Graphic Designing services in Hyderabad,ameerpet­
    Best Ad Making services in Hyderabad,ameerpet­

    ReplyDelete
  5. Here is the investors contact Email details,_   lfdsloans@lemeridianfds.com  Or Whatsapp +1 989-394-3740 that helped me with loan of 90,000.00 Euros to startup my business and I'm very grateful,It was really hard on me here trying to make a way as a single mother things hasn't be easy with me but with the help of Le_Meridian put smile on my face as i watch my business growing stronger and expanding as well.I know you may surprise why me putting things like this here but i really have to express my gratitude so anyone seeking for financial help or going through hardship with there business or want to startup business project can see to this and have hope of getting out of the hardship..Thank You.

    ReplyDelete
  6. Thanks again for all the great information…I am grateful! 1099 MISC Form Online. You can clearly explain about it.

    ReplyDelete
  7. Thanks for Sharing This Useful Information.
    Kalpana Naturals is a AYUSH Certified product manufacturer with trusted range of products like natural floor cleaner liquids, detergents liquids & powders, pest repellents, Pain relief assistance products, clinical products and more. Online Herbal Products Store

    ReplyDelete
  8. Thanks for sharing this helpful content. Hope it will help people.

    ReplyDelete
  9. Nice Post. I was checking constantly this blog and I am impressed! Very useful info specifically the last part ?? I care for such information much. Thank you and good luck.

    best transportation sources in Hyderabad

    ReplyDelete