Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Transpose (2000)

    I am trying to copy and paste special (transpose) several rows of information. To show the data sequentially, i. e., via transpose, I have to copy each row separately. Anyone have a clue how to do a shortcut that would allow me to do it faster?
    Thanks,
    Jeff

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transpose (2000)

    Highlight what you're copying from. Copy. Then move to the first cell in your target. "Edit, Paste specia", click on the "transpose " box, and click "OK".
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Transpose (2000)

    Thanks, Geoff-now, how do I save any formulas in the cells I want to transpose?

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transpose (2000)

    Check the "formulas" checkbox when you're doing the paste special.

    But, just as when you copy formulas, they can change if you haven't used absolute references.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •