Re: How do I automatically add rows...
- From: "David McRitchie" <dmcritchie_xlmvp@xxxxxxxxxxx>
- Date: Thu, 25 Aug 2005 06:42:32 -0400
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/flashfiles/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" <Isobel05@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
> > The Subtotals function: "At each change in" is what I need, but after that I
> > need "add three rows", not a mathematical function.
.
- References:
- How do I automatically add rows...
- From: Isobel05
- Re: How do I automatically add rows...
- From: David McRitchie
- How do I automatically add rows...
- Prev by Date: Store row number after a find
- Next by Date: Using IF & AND command in conjunction
- Previous by thread: Re: How do I automatically add rows...
- Next by thread: Label Columns
- Index(es):
Relevant Pages
|
