To insert blank space between the rows

Question

In the below Excel sheet I have three columns:

column1   |   column2   |  column3
----------------------------------
  A       |     small   |  blue
  B       |     med     |  yellow
  C       |     large   |  green
  D       |     large   |  green

How may I insert blank rows between each of the rows?

@ZAT There are 1000 rows is there is possibility of adding blank row in between each row? — Developer, Nov 22 '14 at 15:13
you should use tag vba or excel-vba while asking solution with code. — ZAT, Nov 22 '14 at 15:14

score 0 · Answer 1 · answered Nov 28 '15 at 15:09

In addition to VBA there are various non-VBA ways to achieve what I understand you to want. Assuming column1 is in A1 of Sheet1, in another sheet in A1, copied across to C1 and then all three formulae copied down to suit:

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

IF
MOD
OFFSET
INT
ROW

To insert blank space between the rows

1 Answers1