I have highlighted in yellow the cells that contain subtotals. Is it possible to create a table style or template that includes subtotals of columns at the bottom and/or subtotals of rows at the right? Is it possible for there to be multi-level subtotals? If there are multi-level subtotals, is it possible to have the multi-level subtotal rows to include both key values and descriptive values shown?įor example, I have attached an image of a Regional & Departmental Costs spreadsheet with two levels of subtotals. Once saved as a template, you can later base new workbooks on this template, which means that the custom table style (along with any other customizations) will be available for you to use. You do that by pressing Ctrl+F12 to display the Save As dialog box and using the Save As Type drop-down list to specify you are saving a template. (You can see it at the top of the styles, in the Custom section, when you click the Foramt As Table tool on the Home tab of the ribbon.) If you want the style to be accessible in future sessions of Excel, then it is best to save the workbook as a template. Your new style is defined, and it will be usable for the balance of the current Excel session. Use the controls in the dialog box to define how you want the style to look.Provide a name for your custom table style.Excel displays the New Table Style dialog box. Scroll down through the options, to the very bottom.Excel displays a variety of formats you can use. Click the Format As Table tool, in the Styles group.Mike wonders if there is a way to save the table style so that he can just use it across many workbooks.Įxcel allows you to create your own table styles through the following general steps:
Instead, he finds that he has to re-create the table style again each time. However, he doesn't know of a way to save this table style so that he can use it the next time he creates a new worksheet. Mike has a table style that he likes to use to format his tables with a certain color, border, etc.
0 kommentar(er)
