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

33 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. You will find a lot of approaches after visiting your post.Thanks for sharing the such information with us to read this...

    girls dresses

    ReplyDelete
  9. Herbal Treatment for Hydrocele can be used to obtain relief from the symptoms such as pain and swelling. Herbal Supplement is used to treat without any side effects.

    ReplyDelete
  10. Natural Remedies for Epididymitis support more than just using one’s cure. If you have an infection, it is very significant to have a supplement with all these cures and visit Herbs Solutions by Nature your healthcare provider to make sure the infection is completely cleared up.

    ReplyDelete
  11. Buy Herbal Product for Delayed Ejaculation It also provides the ability in men to improve their ejaculation. Herbs Solutions by Nature offer an exact cure for Delayed Ejaculation to lessen prolactin levels will allow a man to climax easier.

    ReplyDelete
  12. Buy Herbal Product for Granuloma Annulare that encourages you to treat many skin diseases and issues, for example, scabies, rashes, eczema, psoriasis, skin break out and different diseases. Herbs Solutions by Nature uses herbal products and the skin detox formula to cure granuloma annulare naturally. If tiresome these Natural Remedies for Granuloma Annulare you feel unsavory and congenial.

    ReplyDelete
  13. Natural Remedies for Achalasia dealt with straightforwardly by forceful widening. Natural remedies protect the throat from pain and Dairy products also help with Achalasia disease. Buy Herbal Product for Achalasia provides a supplement to cure Achalasia infection. These are the essential cures that help to improve the throat.

    ReplyDelete
  14. Buy Herbal Product for Peripheral Neuropathy available for complete recovery of the disease. The Peripheral Neuropathy treatment options rest mostly on the primary cause and severity of symptoms. The nature and duration of treatments differ significantly, depending on the symptoms they are facing or the condition they are in. Despite your doctor could help you treat neuropathic pain with the most modern available therapies, there are numerous natural remedies for peripheral neuropathy you could do at home to take care of pain.

    ReplyDelete
  15. At the point when clinical trials demonstrate that another treatment is superior to the standard treatment, the new treatment may turn into the standard treatment. Patients might need to consider participating in a clinical trial. Some clinical trials are open just to patients who have not started treatment. Buy Herbal Product for Waldenstrom’s Macroglobulinemia with Herbs Solutions by Nature.

    ReplyDelete
  16. There is no known medical cure for lichen planus, but Natural Remedies for Lichen Planus is often helpful in assuages itching and improving the appearance of the rash until it goes away. Cure for lichen planus may cost a lot of money, but it usually works – at least in terms of giving enduring relief for an important period of time. Buy Herbal Product for Lichen Planus is a less expensive effective method to cure this disorder.

    ReplyDelete
  17. Home Remedies can significantly reduce tremors, though Benign Essential Tremor cannot be cured overall. Natural Remedies for Benign Essential Tremor in hands, stress balls, or other consolidation exercises can relieve train muscles to decrease tremors in your hands. Buy Herbal Product for Benign Essential Tremor can also be things that are used for very different results in other patients.

    ReplyDelete
  18. On the happier side though, Natural Treatment for Lipoma has no side effects. In fact, you end up success more health aids and decreasing the risks of getting other health problems. Buy Herbal Product for Lipoma Cure by Exercise Links to an external site. will aid in reducing the risks of circulatory disorders while eating a sufficient amount of vitamins will lessen the risks of getting further common infections like flu.

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

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

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

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

    ReplyDelete
  24. 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
  25. 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
  26. Very nice article. I read full article its very good information provided in this blog natural sleep aid

    ReplyDelete
  27. Very useful Information. Kalpana Naturals Provides one of the best product to increase our Immunity.
    Buy our Best product Herbal Immunity Booster by Kalpana Naturals.

    ReplyDelete
  28. Herbal Treatment for Burning Mouth Syndrome is helpful for reducing dry and sore mouth. Herbal Supplement used to treat or reduce the symptoms and causes.

    ReplyDelete
  29. Very nice article. I read full article its very good information provided in this blog Herbal Immunity Booster

    ReplyDelete