Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel copying

Comment:

How do you copy data from rows to columns. I have about 100 cells in a row I need to copy to a column.

Name: Ken
Date: November 21, 1998 at 18:58:34 Pacific

Reply:

Switch rows of cells 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. 1 Select the cells that you want to switch. 2 Click Copy . 3 Select the upper-left cell of the paste area. The paste area must be outside the copy area. 4 On the Edit menu, click Paste Special. Show me 5 Select the Transpose check box.

0

CDplayer not plauing audi...

Give me a hand finding dr...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: You can only do this with small and simple programs (sometimes). When MS Office, which contains Word & Excel, is installed from the original CD it sets up folders and files in all sorts of places. Ma...

Summary: I have a user that is on O/S Win98 and using Excel 2000, she is connected directly to an HP 2000C color printer. When she prints a single copy, the column heading color (medium gray) prints fine - jus...

Summary: Hi there, can some one advise me as to how i can export/ or copy in any way a long list of music (mp3) into excel (v 7), i wish to have a colum going down the page with numbers 1 to maybe 700, and e...