R
Randy
Can rows be moved to colums accross without dragging and dropping?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
not really sure what you're trying to do. Could you give an example?
not really sure what you're trying to do. Could you give an example?
M
Myrna Larson
If you mean transpose, I don't think you can do that with the mouse.
Edit/Copy, then Edit/Paste Special and select the Tranpose option.
Edit/Copy, then Edit/Paste Special and select the Tranpose option.
M
mzehr
Hi Randy,
Without having more information, it sounds like you are
wanting to convert, for instance, one column of data with
multiple rows into several rows spread out over several
columns. If so check out the following website:
http://www.mvps.org/dmcritchie/excel/snakecol.htm
Without having more information, it sounds like you are
wanting to convert, for instance, one column of data with
multiple rows into several rows spread out over several
columns. If so check out the following website:
http://www.mvps.org/dmcritchie/excel/snakecol.htm
G
Gord Dibben
You can use the TRANSPOSE Function and never touch a mouse.
See help on TRANSPOSE.
Remember to select the appropriate number of columns before entering the
Function formula.
Also, it is an Array formula and must be entered using CRTL + SHIFT + ENTER.
Gord Dibben Excel MVP
See help on TRANSPOSE.
Remember to select the appropriate number of columns before entering the
Function formula.
Also, it is an Array formula and must be entered using CRTL + SHIFT + ENTER.
Gord Dibben Excel MVP