Hi Afzaal,

Select the cells,
Edit | Copy
Select a cell outside the copy area
Edit | PasteSpecial | select the 'Transpose' option


---
Regards,
Norman



"AFZAAL" wrote in message
...
dear all
i have some long data in a column and i want it to put into a row. how can
i
do this without cutting individual entries and pasting in row