software

I have a range of sorted data that I have applied subtotals to. I then
'remove all' subtotals, change a few fields, and then apply the same
subtotals. But, in my new subtotal results, there are a number of blank
lines between my last subtotal line and the Grand Total Subtotal line. I
don't know why this is. I normally just delete all those extra lines, but I
would like to find a better solution to avoiding these empty rows. Thanks.
Bunny

When you inserted the subtotals, more rows were added to the used range.

If you don't select your range to use in Data|Subtotals, then excel will guess
at what range to use. (I like to select my range explicitly before
data|subtotals, data|sort, data|pivot table, etc).

If you don't want to select the range, you could use some of the techniques at
Debra Dalgleish's site to reset that used range.

contextures.com/xlfaqApp.html#Unused
BunnyMom wrote:
gt;
gt; I have a range of sorted data that I have applied subtotals to. I then
gt; 'remove all' subtotals, change a few fields, and then apply the same
gt; subtotals. But, in my new subtotal results, there are a number of blank
gt; lines between my last subtotal line and the Grand Total Subtotal line. I
gt; don't know why this is. I normally just delete all those extra lines, but I
gt; would like to find a better solution to avoiding these empty rows. Thanks.
gt; Bunny

--

Dave Peterson

Thanks...this is perfect...just what I was looking for.

quot;Dave Petersonquot; wrote:

gt; When you inserted the subtotals, more rows were added to the used range.
gt;
gt; If you don't select your range to use in Data|Subtotals, then excel will guess
gt; at what range to use. (I like to select my range explicitly before
gt; data|subtotals, data|sort, data|pivot table, etc).
gt;
gt; If you don't want to select the range, you could use some of the techniques at
gt; Debra Dalgleish's site to reset that used range.
gt;
gt; contextures.com/xlfaqApp.html#Unused
gt;
gt;
gt;
gt; BunnyMom wrote:
gt; gt;
gt; gt; I have a range of sorted data that I have applied subtotals to. I then
gt; gt; 'remove all' subtotals, change a few fields, and then apply the same
gt; gt; subtotals. But, in my new subtotal results, there are a number of blank
gt; gt; lines between my last subtotal line and the Grand Total Subtotal line. I
gt; gt; don't know why this is. I normally just delete all those extra lines, but I
gt; gt; would like to find a better solution to avoiding these empty rows. Thanks.
gt; gt; Bunny
gt;
gt; --
gt;
gt; Dave Peterson
gt;