Excell convert formula row to formula column
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. |
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. |
All times are GMT +1. The time now is 05:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com