If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query does not order the same data in the same way | Milković Aleksandar | Running & Setting Up Queries | 10 | December 15th, 2005 12:01 PM |
From several workbooks onto one excel worksheet | steve | General Discussion | 6 | December 1st, 2005 08:03 AM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Struggling with MS Query... | Alex | General Discussion | 5 | July 6th, 2004 11:46 AM |