Thread: Excell convert formula row to formula column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Excell convert formula row to formula column
Use Paste Special from the Edit menu. Check the Transpose option.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"**Danny**" wrote in message
...
Excel 2003 sp2.
I have a row of formulas. I want to convert them into a column of
formulas.
AND conversely - column to row.
On the same sheet or to a different sheet.
How can I doit.


Reply With QuoteReply With Quote