| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change column to a row
How can I change a column of data to a row of data?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change column to a row
TRANSPOSE
-- David Biddulph "yar" wrote in message ... How can I change a column of data to a row of data? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change column to a row
CopyPaste SpecialTranspose.
Paste area cannot overlap copy area and you are limited by number of columns in a row. Gord Dibben MS Excel MVP On Sat, 9 Aug 2008 07:59:00 -0700, yar wrote: How can I change a column of data to a row of data? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change column to a row
"yar" wrote: How can I change a column of data to a row of data? Thanx found my answer but data is limited to little more than 250 entries |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change column to a row
If you are talking of the 256 column limit in Excel 2003, remember that
Excel 2007 changes that to 16384 columns. -- David Biddulph "yar" wrote in message ... "yar" wrote: How can I change a column of data to a row of data? Thanx found my answer but data is limited to little more than 250 entries |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change column numbering to column letters in my spreadsheet view | Excel Discussion (Misc queries) | |||
| Change column color in chart when column value is over/under goal | Charts and Charting in Excel | |||
| How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
| How do I change column into lines on a Line-Column chart? | Charts and Charting in Excel | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Linear Mode
