| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing columns into rows
Is there any way that I can take a sheet and change the way the data is
displayed. For example I have a spreadsheet that has the dates, days of the week, and several other types of information in columns. I would like to be able to change it so the information is displayed in rows, ie, dates going across the top row. Any help is appreicated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing columns into rows
Copy, Paste Special, Transpose
-- Kind regards, Niek Otten "Dave" wrote in message ... Is there any way that I can take a sheet and change the way the data is displayed. For example I have a spreadsheet that has the dates, days of the week, and several other types of information in columns. I would like to be able to change it so the information is displayed in rows, ie, dates going across the top row. Any help is appreicated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing columns into rows
I see where that would help, BUT I keep getting the message that my cell size
and shape are not the same size. Is there any easy fix for that? Thanks "Niek Otten" wrote: Copy, Paste Special, Transpose -- Kind regards, Niek Otten "Dave" wrote in message ... Is there any way that I can take a sheet and change the way the data is displayed. For example I have a spreadsheet that has the dates, days of the week, and several other types of information in columns. I would like to be able to change it so the information is displayed in rows, ie, dates going across the top row. Any help is appreicated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing columns into rows
For Paste, select just one cell
-- Kind regards, Niek Otten "Dave" wrote in message ... I see where that would help, BUT I keep getting the message that my cell size and shape are not the same size. Is there any easy fix for that? Thanks "Niek Otten" wrote: Copy, Paste Special, Transpose -- Kind regards, Niek Otten "Dave" wrote in message ... Is there any way that I can take a sheet and change the way the data is displayed. For example I have a spreadsheet that has the dates, days of the week, and several other types of information in columns. I would like to be able to change it so the information is displayed in rows, ie, dates going across the top row. Any help is appreicated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| How to reverse order of rows and columns | Excel Discussion (Misc queries) | |||
| Changing Columns to Rows Question | Excel Discussion (Misc queries) | |||
| hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Linear Mode
