copy data from column across row

  • Thread starter Thread starter kevinrea
  • Start date Start date
K

kevinrea

Hi guys,

I am trying to copy the data from one column across one row.., in othe
words,.. i want the data to go from left to right across the pag
instead of top to bottom..

Anyone have a way to do this.., maybe a macro or something ?

thanks,
Kevi
 
After you have highlighted the range to be copied from,

right click the mouse & select copy

put the cellpointer to the left most cell of the row then,

right click the mouse again & select paste special this time.

select transpose by checking the box

And hit OK.

The data should be copied horizontally.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
Back
Top