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