copy formulas from horizontal cells into vertical cells.

  • Thread starter Thread starter Little Penny
  • Start date Start date
L

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
 
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.
 
Back
Top