Outlined Data in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steph44haf - 10 Jul 2006 21:19 GMT

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.

Reply to this Message

Dave Peterson - 10 Jul 2006 22:50 GMT

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)

> 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.

Signature

Dave Peterson

Reply to this Message