copy formulas from horizontal cells into vertical cells.

[Little Penny]

How do I copy horizontal cell into vertical cells?

I tried copying my cells horizontally selecting cell where I want them
to go. I use paste special and transpose. Its paste the info but
changed my formulas I want to keep formulas as is.



Thanks

 

[Guest]

If your formulas referenced other cells and did not have absolute references,
then Excel will attempt to change them to the relative references based on
their new cell location. That is the way it is designed.