• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 84
  • Last Modified:

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
0
peispud
Asked:
peispud
  • 2
  • 2
1 Solution
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now