Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Outlined Data in Excel
Can you collapse Text Data in Excel like you can in Word? For example I have
three columns (A, B, C) I want to be able to hide the data in column B and C for example and just see A condensed onto one page. I know you can use the collapse and hide function when you have subtotals, but I am using text. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Outlined Data in Excel
Select the columns and do
Data|Group and outline|Group (and you'll see the outlining symbols at the top of the screen) (Or you could just hide the columns manually) steph44haf wrote: Can you collapse Text Data in Excel like you can in Word? For example I have three columns (A, B, C) I want to be able to hide the data in column B and C for example and just see A condensed onto one page. I know you can use the collapse and hide function when you have subtotals, but I am using text. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |