Re: Transpose a column of formulas in Excel

I use Lotus 1-2-3 so this may not work.

Make a test copy in another folder, just to be safe.

Now try doing a range Cut and the Paste Special to the new range. It should
ask you about the cell contents.
Or, you may have a Transpose option.


-- 
Don
Vancouver, USA, a great city in one of the 45+ countries in America!


"Erv Young" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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