View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default To take the cells in the same row and divide them in rows

Hi,

Do the following;

1. Select the row and copy using the Edit menu.
2. Clck a cell in a different location. and then on the Edit menu, click
Paste Special.
The Paste Special Dialog box is displayed.
3. Select the Transpose check box.
4. Click Ok to return to view the worksheet to view the transposed row.

Challa Prabhu

" wrote:

the same question like before, please answer me.