inserting and deleting blank rows in selected range

S

ssa

I wanted to know how to insert a blank row alternatively between range of
rows. It would be good if u can advise me on this.
I wanted to know how to delete blanks row simultaneously between range of
rows. It would be good if u can advise me on this.
 
M

Mandy11

Highlight the entire row by clicking on the row number (in the gra
area), you may click and drag (if you want to add several rows)

Then right click and hit insert
 
M

Max

I wanted to know how to insert a blank row alternatively
between range of rows

Taken from a previous Tom Ogilvy post ..

Assume you have In Sheet1, in cols A and B, in row1 down

1 a
2 b
3 c
etc

In Sheet2
------------
Put in A1:

=IF(MOD(ROW(),2)=1,OFFSET(Sheet1!$A$1,(ROW()+1)/2-1,COLUMN()-1),"")

Copy A1 across to B1, fill down

You'll get a blank row inserted in-between each entry in Sheet1's cols A and
B

1 a

2 b

3 c
etc

Just select cols A and B, and
do an "in-place" copy > paste special > values
to kill the formulas in col A thereafter
I wanted to know how to delete blanks row simultaneously
between range of rows.

Experiment with this on a back-up copy ..

Select the target column with the blanks in-between

Press F5 > special > check "Blanks" > OK
(This'll select all the blank cells in the column)

Right-click on the selection > Choose Delete ...

Select "Shift cells up" or "Entire row" as desired

Click OK
 
Top