Thread: insert
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default 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