Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format a single column into a row
I have a collection of column headers and simply want to move them into a
single Row up and down. thanks |
#2
|
|||
|
|||
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 "shepbinker" wrote in message ... I have a collection of column headers and simply want to move them into a single Row up and down. thanks |
#3
|
|||
|
|||
shep
They are already in a row(sideways). What you want is for them to be in one column(up and down). EditCopy. Select a column and EditPaste SpecialTransposeOKEsc. Note: you cannot paste to any part of the original row. Gord Dibben Excel MVP On Thu, 3 Feb 2005 08:55:06 -0800, "shepbinker" wrote: I have a collection of column headers and simply want to move them into a single Row up and down. thanks |
#4
|
|||
|
|||
Thanks JulieD this did help...I knew it was simple just couldn't think of
Transpose when I needed too. :-) "JulieD" wrote: 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 "shepbinker" wrote in message ... I have a collection of column headers and simply want to move them into a single Row up and down. thanks |
#5
|
|||
|
|||
Thanks very much.... I had done it before but was just drawing a blank at a
time I needed it. "Gord Dibben" wrote: shep They are already in a row(sideways). What you want is for them to be in one column(up and down). EditCopy. Select a column and EditPaste SpecialTransposeOKEsc. Note: you cannot paste to any part of the original row. Gord Dibben Excel MVP On Thu, 3 Feb 2005 08:55:06 -0800, "shepbinker" wrote: I have a collection of column headers and simply want to move them into a single Row up and down. thanks |
#6
|
|||
|
|||
you're welcome
"shepbink" wrote in message ... Thanks JulieD this did help...I knew it was simple just couldn't think of Transpose when I needed too. :-) "JulieD" wrote: 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 "shepbinker" wrote in message ... I have a collection of column headers and simply want to move them into a single Row up and down. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
merge data from multiple columns to single column | Excel Worksheet Functions | |||
Format Column with Same Function | Excel Worksheet Functions | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How can I combine IF, COLUMN, and LARGE formulas in a single cell? | Excel Worksheet Functions |