| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel: is it possible to move column contents into a line
Excel 2000: is it possible to move column contents into a line?
ie move column contents A B C to become Column headings A B C. How is it done. I used to be able to 'transpose' on earlier versions of Excel but am unable to find it here. Thanks |
|
#2
|
|||
|
|||
|
Copy your cells
select the new location edit|paste special|transpose (at the bottom) Remember that you can only use 256 columns. Ginger wrote: Excel 2000: is it possible to move column contents into a line? ie move column contents A B C to become Column headings A B C. How is it done. I used to be able to 'transpose' on earlier versions of Excel but am unable to find it here. Thanks -- Dave Peterson |
|
#3
|
|||
|
|||
|
Excellent! Many thanks
Ginger "Dave Peterson" wrote: Copy your cells select the new location edit|paste special|transpose (at the bottom) Remember that you can only use 256 columns. Ginger wrote: Excel 2000: is it possible to move column contents into a line? ie move column contents A B C to become Column headings A B C. How is it done. I used to be able to 'transpose' on earlier versions of Excel but am unable to find it here. Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Linear Mode
