need to insert 9 blank rows into each of 105 pages in an excel 2003 worksheet

[algerhiss5]

need to insert 9 blank rows into each of 105 pages in an excel 2003 worksheet.

At present every cell in all 4922 rows are filled with data.

[:) Sixthsense :)]

Try it in the copy of the workbook.

Do right click on sheet tab and Click Select All Sheets and place the cursor where you would like to insert rows and Insert Required Number of rows which will be performed in all sheets. Once the insert process is over then do right click on sheet tab and select Ungroup Sheets.

Caution: when you have selected all sheets then whatever the action you perform will be applied to all sheets.

[algerhiss5]

Sixthsense was cool to quickly
propose a solution.

Tried the solution, but no cigar.

But appreciate idea.

Starting over.

Excel 2003 Worksheet.

3813 Rows

80 pages

Each page has 49 rows

All cells in all rows have
data in them.

I need to have the 1st 8 rows
of each page empty so I can
paste a page heading there.

Have tried solving with Headers,
but cannot make that work.

Anybody have any ideas, please?

[algerhiss5]

The wording of Sixthsense's proposed solution has given me an idea.

I am working with ONE worksheet only.

So I need a command something like

"select all pages" (within same worksheet)

then

add the number of empty rows I need for all pages to
the page I am on

then

a command like

"separate all pages"

But I do not see those commands anywhere.

Is anybody out there?

I need your superior skills please.

Alger Hiss

[:) Sixthsense :)]

I am working with ONE worksheet only.

Oops. Regret for the wrong direction, since misinterpreted pages as worksheets.

Insert 9 blank rows into each of 105 pages

But when you insert 9 blank rows on each page then the previously defined pages may get moved to some other page range.

Or confirm us whether your current page ranges can able to hold another 9 EXTRA LINES?