Message Font: Serif | Sans-Serif
 
No. of Recommendations: 0
Thank all of you who helped with my E-mail forwarding problem.

If I copy a column of information and paste into excel, is there a way to convert that column of info to rows of information (Office 97 version)? I used to be able to do this with the old Quattro Program.

Thanks,
Chuck


Print the post Back To Top
No. of Recommendations: 1
I got this form the help in Excel 2000

Hope this helps.

Transpose rows to columns or columns to rows
Data from the top row of the copy area appears in the left column of the paste area, and data from the left column appears in the top row.

Select the cells that you want to switch.
Click Copy .
Select the upper-left cell of the paste area. The paste area must be outside the copy area.
Click the arrow to the right of Paste and then click Transpose.
Print the post Back To Top
No. of Recommendations: 0
PERFECT
"Transpose"...that was the correct word.
Thank you so much.

Chuck
Print the post Back To Top
No. of Recommendations: 0
You're welcome.
Print the post Back To Top
Advertisement