| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtotal levels
I am working with a large spreadsheet and need to make subtotals. The
subtotal lines are appearing on the spreadsheet but the levels are not appearing to the left of the number lines. How do I see the levels so I can use them? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtotal levels
Maybe...
Tools|Options|View tab|check Outline symbols (xl2003 menus) MayJuneJuly wrote: I am working with a large spreadsheet and need to make subtotals. The subtotal lines are appearing on the spreadsheet but the levels are not appearing to the left of the number lines. How do I see the levels so I can use them? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtotal levels
This worked for the spreadsheet I was on. Now do you know how to make it work
all the time without having to go to tools|options|view tab|check Outline symbols? I am using excel 2003 "Dave Peterson" wrote: Maybe... Tools|Options|View tab|check Outline symbols (xl2003 menus) MayJuneJuly wrote: I am working with a large spreadsheet and need to make subtotals. The subtotal lines are appearing on the spreadsheet but the levels are not appearing to the left of the number lines. How do I see the levels so I can use them? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtotal levels
That's the default status for me (also xl2003).
If you start a new workbook, add some test data, then do data|subtotals, do you see the outlining symbols? Maybe someone turned them off for the workbooks that you're using. MayJuneJuly wrote: This worked for the spreadsheet I was on. Now do you know how to make it work all the time without having to go to tools|options|view tab|check Outline symbols? I am using excel 2003 "Dave Peterson" wrote: Maybe... Tools|Options|View tab|check Outline symbols (xl2003 menus) MayJuneJuly wrote: I am working with a large spreadsheet and need to make subtotals. The subtotal lines are appearing on the spreadsheet but the levels are not appearing to the left of the number lines. How do I see the levels so I can use them? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtotal levels
They must be turned off because I have to do these steps on every worksheet.
Do you know how to turn them on permenantly? "Dave Peterson" wrote: That's the default status for me (also xl2003). If you start a new workbook, add some test data, then do data|subtotals, do you see the outlining symbols? Maybe someone turned them off for the workbooks that you're using. MayJuneJuly wrote: This worked for the spreadsheet I was on. Now do you know how to make it work all the time without having to go to tools|options|view tab|check Outline symbols? I am using excel 2003 "Dave Peterson" wrote: Maybe... Tools|Options|View tab|check Outline symbols (xl2003 menus) MayJuneJuly wrote: I am working with a large spreadsheet and need to make subtotals. The subtotal lines are appearing on the spreadsheet but the levels are not appearing to the left of the number lines. How do I see the levels so I can use them? -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtotal levels
You can create a new workbook template and save it in your XLStart folder.
Name it Book.xlt and do as much formatting as you want as well as changing this setting for each worksheet in that template In xl2003, a new workbook will be created when you click on the New Icon on the standard toolbar. Create another workbook in the same folder, but name it Sheet.xlt. This template is used when you add a worksheet to an existing workbook. You could also record a macro when you make the change manually. Then just rerun this macro whenever you need it. MayJuneJuly wrote: They must be turned off because I have to do these steps on every worksheet. Do you know how to turn them on permenantly? "Dave Peterson" wrote: That's the default status for me (also xl2003). If you start a new workbook, add some test data, then do data|subtotals, do you see the outlining symbols? Maybe someone turned them off for the workbooks that you're using. MayJuneJuly wrote: This worked for the spreadsheet I was on. Now do you know how to make it work all the time without having to go to tools|options|view tab|check Outline symbols? I am using excel 2003 "Dave Peterson" wrote: Maybe... Tools|Options|View tab|check Outline symbols (xl2003 menus) MayJuneJuly wrote: I am working with a large spreadsheet and need to make subtotals. The subtotal lines are appearing on the spreadsheet but the levels are not appearing to the left of the number lines. How do I see the levels so I can use them? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtotal levels
Thank you for your help. This will work to some degree but I am working with
another software and exporting to excel. I will just have to do the additional steps in the exported documents. Thank you so much for your assitance. "Dave Peterson" wrote: You can create a new workbook template and save it in your XLStart folder. Name it Book.xlt and do as much formatting as you want as well as changing this setting for each worksheet in that template In xl2003, a new workbook will be created when you click on the New Icon on the standard toolbar. Create another workbook in the same folder, but name it Sheet.xlt. This template is used when you add a worksheet to an existing workbook. You could also record a macro when you make the change manually. Then just rerun this macro whenever you need it. MayJuneJuly wrote: They must be turned off because I have to do these steps on every worksheet. Do you know how to turn them on permenantly? "Dave Peterson" wrote: That's the default status for me (also xl2003). If you start a new workbook, add some test data, then do data|subtotals, do you see the outlining symbols? Maybe someone turned them off for the workbooks that you're using. MayJuneJuly wrote: This worked for the spreadsheet I was on. Now do you know how to make it work all the time without having to go to tools|options|view tab|check Outline symbols? I am using excel 2003 "Dave Peterson" wrote: Maybe... Tools|Options|View tab|check Outline symbols (xl2003 menus) MayJuneJuly wrote: I am working with a large spreadsheet and need to make subtotals. The subtotal lines are appearing on the spreadsheet but the levels are not appearing to the left of the number lines. How do I see the levels so I can use them? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtotal levels
Are you using crystal reports and exporting to excel? I use crystal to
export data from my accounting software and then export to excel to manipulate the data. I have to copy the data to a new worksheet to get the level bars to show. "MayJuneJuly" wrote: Thank you for your help. This will work to some degree but I am working with another software and exporting to excel. I will just have to do the additional steps in the exported documents. Thank you so much for your assitance. "Dave Peterson" wrote: You can create a new workbook template and save it in your XLStart folder. Name it Book.xlt and do as much formatting as you want as well as changing this setting for each worksheet in that template In xl2003, a new workbook will be created when you click on the New Icon on the standard toolbar. Create another workbook in the same folder, but name it Sheet.xlt. This template is used when you add a worksheet to an existing workbook. You could also record a macro when you make the change manually. Then just rerun this macro whenever you need it. MayJuneJuly wrote: They must be turned off because I have to do these steps on every worksheet. Do you know how to turn them on permenantly? "Dave Peterson" wrote: That's the default status for me (also xl2003). If you start a new workbook, add some test data, then do data|subtotals, do you see the outlining symbols? Maybe someone turned them off for the workbooks that you're using. MayJuneJuly wrote: This worked for the spreadsheet I was on. Now do you know how to make it work all the time without having to go to tools|options|view tab|check Outline symbols? I am using excel 2003 "Dave Peterson" wrote: Maybe... Tools|Options|View tab|check Outline symbols (xl2003 menus) MayJuneJuly wrote: I am working with a large spreadsheet and need to make subtotals. The subtotal lines are appearing on the spreadsheet but the levels are not appearing to the left of the number lines. How do I see the levels so I can use them? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal Levels not showing in Excel | Excel Worksheet Functions | |||
| Subtotal error to expand Outline Levels | Excel Discussion (Misc queries) | |||
| Multiple Subtotal levels in Excel 2003 | Excel Worksheet Functions | |||
| No Buttons to Control Subtotal Levels!?!? | Excel Discussion (Misc queries) | |||
| How do I get Multiple subtotal levels in EXCEL? | Excel Discussion (Misc queries) | |||
Linear Mode
