Posted to microsoft.public.excel.newusers
|
|
how do I transpose a row of cells to a column between worksheets?
Depending what is needed:
Use Copy followed by Edit | Paste Special with Transpose selected
or use the TRANSPOSE function - see Help for more then come back if you need
more
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Mike C" <Mike wrote in message
...
I want to transpose a row of cells (containing a formula) from one
worksheet
into a column of cells in another worksheet. How do I do this?
|