- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Transpose, but preserve, a range of formulas?

Subject: | Transpose, but preserve, a range of formulas? |

Posted by: | Erv Young (ervyou…@nc.rr.com) |

Date: | 22 Oct 2003 |

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

- Re: Transpose, but preserve, a range of formulas? posted by Ken Wright on Wed, 22 Oct 2003