ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Odd spreadsheet control (https://www.excelbanter.com/excel-discussion-misc-queries/93717-odd-spreadsheet-control.html)

39N 95W

Odd spreadsheet control
 
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. Choate

Odd spreadsheet control
 
That spreadsheet is using subtotals. Look under DATASUBTOTALS on the menu bar.

--
RMC,CPA


"39N 95W" wrote in message ...
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?








All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com