| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a row into a column
I have pasted a bunch of names into an excel sheet, and they appear in one
single row and I'd like them to appear in a column to that I can sort easily. Please help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting a row into a column
select the cells in the row
copy select a new cell further down edit paste special transpose ok -- Allllen "Jen711" wrote: I have pasted a bunch of names into an excel sheet, and they appear in one single row and I'd like them to appear in a column to that I can sort easily. Please help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting a row into a column
Jen
Don't forget that you could leave the data as is and sort on the row. Select the row. Data<SortOptions "Left to right". I would prefer to have the data in a column as Allllen suggested. Gord Dibben MS Excel MVP On Wed, 8 Nov 2006 10:15:02 -0800, Allllen wrote: select the cells in the row copy select a new cell further down edit paste special transpose ok -- Allllen "Jen711" wrote: I have pasted a bunch of names into an excel sheet, and they appear in one single row and I'd like them to appear in a column to that I can sort easily. Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting of rows | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
| conditional formatting based on column | Excel Discussion (Misc queries) | |||
Hybrid Mode
