insert a new row between exsisting rows on entire worksheet

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
[email protected]
"Andy" <[email protected]> wrote in message
news:[email protected]...
> 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