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.

"Little Penny" wrote:

> 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
>
>