ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting Subtotals (https://www.excelbanter.com/excel-discussion-misc-queries/26008-formatting-subtotals.html)

slh

Formatting Subtotals
 
When using Data, Subtotals to create subtotals in a detailed spreadsheet,
how do I set the format so that all subtotal lines are bolded and are
followed by a specified number of blank rows?

Duke Carey

One option -

Collapse the sheet to show only the subtotals, then select visible cells
only (F5SpecialVisible Cells only)

Then Bold those cells and, instead of adding empty rows, make the subtotal
rows taller and format them with the vertical alignment at the top


"slh" wrote:

When using Data, Subtotals to create subtotals in a detailed spreadsheet,
how do I set the format so that all subtotal lines are bolded and are
followed by a specified number of blank rows?



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

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