PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup Outlined Data in Excel

Reply

Outlined Data in Excel

 
Thread Tools Rate Thread
Old 10-07-2006, 09:19 PM   #1
=?Utf-8?B?c3RlcGg0NGhhZg==?=
Guest
 
Posts: n/a
Default 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.
  Reply With Quote
Old 10-07-2006, 10:50 PM   #2
Dave Peterson
Guest
 
Posts: n/a
Default Re: 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 With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off