ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Outlined Data in Excel (https://www.excelbanter.com/setting-up-configuration-excel/98492-outlined-data-excel.html)

steph44haf

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.

Dave Peterson

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


All times are GMT +1. The time now is 03:39 PM.

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