Hi Isobel,
Another way sticking strictly to subtotals (no conditional formatting,
and no macros) which may give your report a cleaner appearance
rather than looking at 3 rows of empty cells.

On your subtotals select the level [+] on the left,
then select all of your used rows (optional won't change printed report),
then Alt+; (semi-colon) or the "select visible" toolbar icon
then adjust the row height. You can also use format, cells,
alignment to change vertical alignment of text (top, center, bottom).

The optional step is only so you don't have to look at extra high
rows after the end of your data, won't affect your printing.

If you are on high-speed access (probably about 3 minutes of viewing)
Macromedia Flash (SWF) Movie Created by Camtasia Studio 2
http://www.datapigtechnologies.com/f...subtotals.html
series of Excel tutorials
http://www.datapigtechnologies.com/ExcelMain.htm

More on shortcuts
http://www.mvps.org/dmcritchie/excel/excel.htm
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Isobel05" wrote
The Subtotals function: "At each change in" is what I need, but after that I
need "add three rows", not a mathematical function.