Hi,

You could also try this. Suppose your data is in range B5:B55. In range
C5"C55, type values from 1-51. Now copy C5:C55 and paste it in C56:C106 and
then in rangeC107:C157.

Now select B5:C157 and sort (in ascending order) on column C.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Rajat Soni" wrote in message
...
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.