ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Expansion column to the left of data (+ -) how to (https://www.excelbanter.com/excel-discussion-misc-queries/203404-expansion-column-left-data-how.html)

Utah Tom

Expansion column to the left of data (+ -) how to
 
Hi,

I saw a work sheet out of SQL Reporting Services that had levels to the left
of the data where you could expand to more detail levels. How do I set that
up on an exisiting workksheet?

Rick Rothstein

Expansion column to the left of data (+ -) how to
 
It sounds like you might want the Group and Outline option located under the
Data menu item. You can do a help search on the word Group and on the word
Outline to see if this option is what you are looking for.

--
Rick (MVP - Excel)


"Utah Tom" <Utah wrote in message
...
Hi,

I saw a work sheet out of SQL Reporting Services that had levels to the
left
of the data where you could expand to more detail levels. How do I set
that
up on an exisiting workksheet?




All times are GMT +1. The time now is 02:45 AM.

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