Formatting a row into a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
select the cells in the row
copy
select a new cell further down
edit > paste special
transpose
ok
 
Jen

Don't forget that you could leave the data as is and sort on the row.

Select the row.

Data<Sort>Options "Left to right".

I would prefer to have the data in a column as Allllen suggested.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the =page! feature to transpose a row to column 0
how do i select all cells in a worksheet 3
rearranging rows from a single column 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Is this possible?? 3
Excel Help to copy information from one row at a time to another sheet 1
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Multiple column search and Copy 7

Back
Top