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

17 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. Nice Information
    Yaaron Studios is one of the rapidly growing editing studios in Hyderabad. We are the best Video Editing services in Hyderabad. We provides best graphic works like logo reveals, corporate presentation Etc. And also we gives the best Outdoor/Indoor shoots and Ad Making services.
    video editing studios in hyderabad
    short film editors in hyderabad
    corporate video editing studio in hyderabad
    ad making company in hyderabad

    ReplyDelete
  5. 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
  6. 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
  7. Thanks again for all the great information…I am grateful! 1099 MISC Form Online. You can clearly explain about it.

    ReplyDelete
  8. 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
  9. Thanks for sharing this helpful content. Hope it will help people.

    ReplyDelete
  10. Thanks for sharing useful information, Regards
    Herbal Sleep Supplement

    ReplyDelete
  11. Thanks for sharing this useful information ,regards.
    Ayurvedic Products online store

    ReplyDelete
  12. 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
  13. Nice Blog, Thanks for sharing this useful information.
    Herba Mask Supplement 5 ML Roll-On is a unique product by Kalpana Naturals that protects you from harmful germs, smoke, toxins from entering through your mask.
    face mask refresher

    ReplyDelete