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!

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!

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!