I have 25 pivot tables on one worksheet each one of which is placed just
one row below the previous one.

I'd like to seperate them with empty space by making each one start on
the thousand'th row. That is, the first would be on row 1, the second
on row 1,001, etc and the last one on row 25,001. That way I can
always add more data to the original data set and expand the pivot
tables without risking them overlapping with each other (which is a
no-no). Is there a way to tell excel to insert, for example, 937 empty
rows between two existing rows? Otherwise I will have to keep inserting
by trial and error (25 times) until I hit the target row.


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=376840

Look at the little box on the far left in the formula bar for example if you
are in cell A4 it will say A4

go to the cell where you want to start inserting rows say A64

highlight where it says A64 and enter 64:1000
hit enter and <edit< insert row.

"cwinters" wrote:


I have 25 pivot tables on one worksheet each one of which is placed just
one row below the previous one.

I'd like to seperate them with empty space by making each one start on
the thousand'th row. That is, the first would be on row 1, the second
on row 1,001, etc and the last one on row 25,001. That way I can
always add more data to the original data set and expand the pivot
tables without risking them overlapping with each other (which is a
no-no). Is there a way to tell excel to insert, for example, 937 empty
rows between two existing rows? Otherwise I will have to keep inserting
by trial and error (25 times) until I hit the target row.


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=376840