Odd spreadsheet control

3

39N 95W

Excel 2002 SP3
XP Pro SP2

I received two spreadhseets from my boss that I'm supposed to geocode.
Anyway, to the left of the row numbers is a collapsable bracket-type control
that you see in things like Windows Explorer, etc. There are "+" boxes and
"-" boxes, and best I can tell they hide or unhide rows. I've never seen
anything like this; can somebody identify this? Is it a Lotus control or
something?
 
R

R. Choate

That spreadsheet is using subtotals. Look under DATA>SUBTOTALS on the menu bar.

--
RMC,CPA


Excel 2002 SP3
XP Pro SP2

I received two spreadhseets from my boss that I'm supposed to geocode.
Anyway, to the left of the row numbers is a collapsable bracket-type control
that you see in things like Windows Explorer, etc. There are "+" boxes and
"-" boxes, and best I can tell they hide or unhide rows. I've never seen
anything like this; can somebody identify this? Is it a Lotus control or
something?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clicking on numbered boxes, plus and minus sign to show and hide d 1
Cannot unhide the hidden rows in my spreadsheet 3
Hiding/Concealing columns 2
numbered squares top left corner of spreadsheet 2
How to lhide - lock columns (with a passord) BUT without preventin 1
hide / unhide names 4
how do I expand collapsed rows in excel 2
Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! 6

Top