insert a new row between exsisting rows on entire worksheet

A

Andy

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.
 
K

Kevin B

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.
 
R

Rae Drysdale

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?
 
D

Don Guillett

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
 
A

Andy

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.
 
S

shumaker

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
 
Top