«

»

Mar 25

Transposing Formulas

When copying a sheet full of formulas that refer to other worksheets and using paste special | transpose to place them in a new worksheet, the formulas reference incorrect cells. A simple trick is to use ctrl-h (replace) to change all the “=” signs to a benign value (such as AAAA or 9999), then copy and transpose. Once in the new worksheet, you can use the same process to change the 9999 back to = and all your formulas reference the right cells.