formatting vertical lists to horizontal columns

G

glenn

Hi all,
I have a long vertical list of names that I need to cut and paste into a
horizontal list. Help please!
 
R

Ron Coderre

Try this:

Select the vertical range of cells

From the Excel main menu:
<edit><copy>

Select the first cell of the new horizontal location
<edit><paste special>
Check: Transpose
Click the [OK] button

Then erase the original range of cells

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP
 

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

How to change margins around bullets in list 1
Copy addition formula of non-consecutive horizontal cells 2
Vertical short line in front of word 0
Move Chart with Text 0
How to use Sumifs with vertically and horizontally criterias 1
Can't drag to align shapes vertically or horizontally 0
How to Convert same horizontal row to vertical row in Excel? 3
How to convert vertically address list to horizontal 2

Top