| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you convert a list that runs vertically to horizoontally?
How would you convert a spreadsheet from:
House Car Boat to : House Car Boat |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you convert a list that runs vertically to horizoontally?
Try this:
Select the vertical range of cells EditCopy Select the upper left corner cell of the destination EditPaste Special Check: Transpose Click the [OK] button Does that help? *********** Regards, Ron XL2002, WinXP-Pro "JHoleman1" wrote: How would you convert a spreadsheet from: House Car Boat to : House Car Boat |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you convert a list that runs vertically to horizoontally?
Copy the data you wish to transpose, then click EDIT in the menu, select
PASTE SPECIAL and check off the TRANSPOSE check box. -- Kevin Backmann "JHoleman1" wrote: How would you convert a spreadsheet from: House Car Boat to : House Car Boat |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you convert a list that runs vertically to horizoontally?
Highlight your range of data
COPY Select the first cell of your new range (cannot overlap with old range) PASTE SPECIAL Click the box for "Transpose" Click OK Delete your old data HTH, Elkar "JHoleman1" wrote: How would you convert a spreadsheet from: House Car Boat to : House Car Boat |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you convert a list that runs vertically to horizoontally?
Copy then Paste Special, Transpose
"JHoleman1" wrote: How would you convert a spreadsheet from: House Car Boat to : House Car Boat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a dependent list, to a current list? | Excel Discussion (Misc queries) | |||
| Update master list with other lists | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
| how do I convert a list in Excel to mailing labels | Setting up and Configuration of Excel | |||
Hybrid Mode
