Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop style for col A changing to style of co D date vs $ | Setting up and Configuration of Excel | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
Changing from format style to list style | Excel Worksheet Functions | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
What is meant by adding outline to data in excel single line style | Excel Discussion (Misc queries) |