Formatting Subtotals

G

Guest

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?
 
G

Guest

One option -

Collapse the sheet to show only the subtotals, then select visible cells
only (F5>Special>Visible 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top