insert
On Thu, 16 Jul 2009 23:25:17 -0700 (PDT), Rajat Soni
wrote:
hello all
I have a column full of data now I want to insert two blank cells in
my column below each cell so that I have two blank cells below every
filled data, please tell me a shortcut as the data is very big and
inserting manually is very tedious.
If you don't want to use a macro you may try this one:
Assuming your data is in column A starting on row 1,
put this formula in the first row of a free helper column:
=IF(MOD(ROW(),3)=1,OFFSET(A$1,INT(ROW()/3),,),"")
Copy the formula down as far as needed, then copy the column
and "Paste Special/Values" it onto column A. Finally clear the helper
column.
Hope this helps / Lars-Åke
|