Excel done in a way that I haven't seen before

Hi all

I have received an excel workbook (many sheets).  Obviously the person who created the worksheets is very versed in Excel.

Please see the picture included.  This pic snippet came from the extreme left edge of the sheet.  You see the row numbers to the right of the picture.

On top I see 1,2,3  and  below that of course you see the sliders.

I can do what this person does with vba.   The controls hide rows and columns.

My question :  What is this?  I can't find vba code.  I dug  around the sheet looking for some sort of addon that could produce this?

Thank you for your help.
excel.png
peispudAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zorvek (Kevin Jones)ConsultantCommented:
What you are seeing are row and column groupings. Look on the Data tab in the Outline section for the grouping controls.

Kevin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Wayne Taylor (webtubbs)Commented:
It's called Grouping and is generally setup manually. See here for more info.
0
Wayne Taylor (webtubbs)Commented:
Typical. Kevin beat me again....
0
zorvek (Kevin Jones)ConsultantCommented:
I beat the Aussie by 2 seconds!
0
peispudAuthor Commented:
Got it!
Thank you both.
I could not taint the rivalry  by awarding equal points even though both correct answers were separated by two seconds. :)
In the best spirit of competition and with my sincere gratitude I will give the points to Kevin.
Thank you!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.