Format a single column into a row

S

shepbinker

I have a collection of column headers and simply want to move them into a
single Row up and down.

thanks
 
J

JulieD

Hi

select your headers and copy them
choose a blank cell in the row you want to paste them into and choose
edit / paste special - transpose - OK

delete the original range if you want to

cheers
JulieD
 
G

Gord Dibben

shep

They are already in a row(sideways).

What you want is for them to be in one column(up and down).

Edit>Copy.

Select a column and Edit>Paste Special>Transpose>OK>Esc.

Note: you cannot paste to any part of the original row.


Gord Dibben Excel MVP
 
S

shepbink

Thanks JulieD this did help...I knew it was simple just couldn't think of
Transpose when I needed too. :)
 
S

shepbink

Thanks very much.... I had done it before but was just drawing a blank at a
time I needed it.
 
Top