Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rotate the display of a spreadsheet
I have a SS that is imported from ACCESS that has a lot of field names across
the top, and just a few rows along the side. Does Excel 2003 have a function or utility or tool that will allow me to rotate the display so the names are down the side that the data runs aligns with it? col1 col2 col3 a b c would become col1 a col2 b col3 c |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rotate the display of a spreadsheet
Copy the cells, then do a Paste Special and check the box for 'Transpose'
"Dave" wrote: I have a SS that is imported from ACCESS that has a lot of field names across the top, and just a few rows along the side. Does Excel 2003 have a function or utility or tool that will allow me to rotate the display so the names are down the side that the data runs aligns with it? col1 col2 col3 a b c would become col1 a col2 b col3 c |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rotate the display of a spreadsheet
Try this:
Select the range of imported cells From the Excel Main Menu: <edit<copy Select the cell that will be the top left cell of the re-organized data. <edit<paste special Check: Transpose....Click [OK] Does that help? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "Dave" wrote in message ... I have a SS that is imported from ACCESS that has a lot of field names across the top, and just a few rows along the side. Does Excel 2003 have a function or utility or tool that will allow me to rotate the display so the names are down the side that the data runs aligns with it? col1 col2 col3 a b c would become col1 a col2 b col3 c |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I display all the rows in a spreadsheet? | New Users to Excel | |||
How to display the filename in spreadsheet | Excel Worksheet Functions | |||
How do I rotate data in a spreadsheet so that rows become columns? | Excel Discussion (Misc queries) | |||
rotate rows and columns in a spreadsheet | Excel Discussion (Misc queries) | |||
How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) |