
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
I'm using Excel 2000. I have a column (precisely, a 1-column by 12-row range) containing formulas. I want to end up with a transposed copy of this range (12 columns by 1 row) in which each cell contains exactly the same formula as the corresponding cell of the source range. For a simple example, suppose range H7:H18 contains these formulas: H7 =E7+G7 H8 =E8+G8 etc. I want to copy this range into C44:N44 so that I end up with C44 =E7+G7 C45 =E8+G8 etc. Is there an easy, direct way to do that? If not, is there an indirect way, short of brute force, and how does it work? Thanks in advance. --Erv
| <-- __Chronological__ --> | <-- __Thread__ --> |