insert a new row between exsisting rows on entire excel worksheet. in other
words, add a new blank row between exsisting rows without having to do it one
at a time.

If you mean entire workbook, not entire worksheet, you can click on the first
sheet tab, hold down Ctrl and click on the last sheet tab. Select the rows
where you want the insertion done and click INSERT on the menu and select
ROWS. The inserted row is inserted across all selected sheets.
--
Kevin Backmann


"Andy" wrote:

insert a new row between exsisting rows on entire excel worksheet. in other
words, add a new blank row between exsisting rows without having to do it one
at a time.

Right click on the row number and select Insert. If you want to insert two
rows, hightlight two row, etc.
If you want to keep repeating you can use Ctrl+Y to repeat row insert (or
hightlight two rows and Ctrl+Y to insert 2 rows).

Does this answer your question?
--
Rae Drysdale


"Kevin B" wrote:

If you mean entire workbook, not entire worksheet, you can click on the first
sheet tab, hold down Ctrl and click on the last sheet tab. Select the rows
where you want the insertion done and click INSERT on the menu and select
ROWS. The inserted row is inserted across all selected sheets.
--
Kevin Backmann


"Andy" wrote:

insert a new row between exsisting rows on entire excel worksheet. in other
words, add a new blank row between exsisting rows without having to do it one
at a time.

try this loop
Sub insertrows()
For i = Cells(Rows.Count, "a").End(xlUp).Row To 2 Step -1
Rows(i).Insert
Next i
End Sub


--
Don Guillett
SalesAid Software

"Andy" wrote in message
...
insert a new row between exsisting rows on entire excel worksheet. in
other
words, add a new blank row between exsisting rows without having to do it
one
at a time.

Can do this. I mean just the worksheet. I have numbered column A with
numbers 1 though 50. Now i need to put a new row between each number so that
it will look like 1, blank row, 2, blank row, 3, blank row and so on.

"Kevin B" wrote:

If you mean entire workbook, not entire worksheet, you can click on the first
sheet tab, hold down Ctrl and click on the last sheet tab. Select the rows
where you want the insertion done and click INSERT on the menu and select
ROWS. The inserted row is inserted across all selected sheets.
--
Kevin Backmann


"Andy" wrote:

insert a new row between exsisting rows on entire excel worksheet. in other
words, add a new blank row between exsisting rows without having to do it one
at a time.

If your objective is to have space between numbers, the easiest way is
to highlight rows 1-50 and double the row height. If you need a blank
row for input, you will need one of the other solutions.
ss


--
shumaker
------------------------------------------------------------------------
shumaker's Profile: http://www.excelforum.com/member.php...o&userid=13226
View this thread: http://www.excelforum.com/showthread...hreadid=538411