Hey guys I am pretty new to excel and I wanted to organize my work better.
I was wondering if I could organize it such that when I click on a worksheet, it would give me multiple worksheets.
Example: http://imgur.com/fP7xnIC
As you can see "Apple", "Orange", "Watermelon", "Banana" and "Strawberry" are all spread out which takes up space at the bottom.
I want to make it such that when you click "Fruits", it will give you the option to choose "Apple", "Orange", "Watermelon", "Banana" or "Strawberry".
Is there a way to do it or something similar? This will make my excel neater and it will be easier for me to navigate.
Thanks in advance!
asd.jpg
Bookmarks