Copying Column Data and Pasting it into a Row

H

Hulk

Is it possible to take data in a single COLUMN on a worksheet and past
it into a ROW on another worksheet in the same workbook?

Obviously, I could do this manually but I would like to do it with
few mouse strokes as there is a lot of data.

Thanks!

Hul
 
A

AnnaV

In the first cell in the row that you want to copy it to put =A1 an
then copy across the row

A1 being your first cell in the column you want to copy
 
M

Myrna Larson

Assuming you include clicking on options in menus and dialog boxes as mouse
strokes, you must Copy, then Edit/Paste Special and select the TRANSPOSE
option.
 
G

Gord Dibben

Copy>Paste Special>Transpose.

NOTE: you will be limited to 256 entries going from column to row.

Gord Dibben Excel MVP
 
Top