ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Outline using style (https://www.excelbanter.com/excel-worksheet-functions/185430-outline-using-style.html)

boardrider

Outline using style
 
Hi everyone,

I would like create an outline using Style by creating styles called
"RowLevel_1", "RowLevel_2", etc... then assign those styles to certain rows.
From Data -- Group and Outline -- Auto Outline. However I got an error
message saying that "Cannot create an Outline". I wonder what I did wrong.
Please help. I am using Excel 2002.

Thanks,
T

Spiky

Outline using style
 
On Apr 28, 5:04 pm, boardrider
wrote:
Hi everyone,

I would like create an outline using Style by creating styles called
"RowLevel_1", "RowLevel_2", etc... then assign those styles to certain rows.
From Data -- Group and Outline -- Auto Outline. However I got an error
message saying that "Cannot create an Outline". I wonder what I did wrong.
Please help. I am using Excel 2002.

Thanks,
T


I don't think you and Excel mean the same thing when you say
"outline". Outline mode in Excel is usually used for subtotals, it
allows you to hide details quickly, showing only the subtotals. Try
turning on Subtotals in the Data menu to see what an Excel Outline
looks like.

You may want to look into Autoformat instead for the formatting you
want. Or use Word.


All times are GMT +1. The time now is 11:38 PM.

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