Re: Transpose a column of formulas in Excel

Do you really need a copy of the formulas, or will a linked range do.  Both are 
possible,
but the
linked range is slightly quicker to do:-

With your data in say A1:A5, select say C1:G1 and type =TRANSPOSE(A1:A5) and then array
enter it
using CTRL+SHIFT+ENTER at the same time.

Other way is to select your range of formulas in A1:A5, do Edit / replace and replace =
with %%.
Then copy the range A1:A5 and Edit / Paste Special / Transpose wherevere you want.  
then
select
your new tranposed range and do Edit / Replace replacing %% with =.

-- 
Regards
           Ken.......................<snip>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003