Format a single column into a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

thanks
 
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
 
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
 
Thanks JulieD this did help...I knew it was simple just couldn't think of
Transpose when I needed too. :-)
 
Thanks very much.... I had done it before but was just drawing a blank at a
time I needed it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
counting blank cells within two columns 2
How do I combine these columns into one? 2
Excel Help to copy information from one row at a time to another sheet 1
Multiple columns into single row 3
Convert table to a single column 1
Sorting issue with frozen panes 11
Move data from every other row to columns 0

Back
Top