Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Paste Special -> Transpose not working

  1. #1
    New Member
    Join Date
    Mar 2007
    Location
    Sarnia, Ontario
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Paste Special -> Transpose not working

    I did a search in here but didn't find an answer so here goes nothing...

    I have a spreadsheet with data from A1 to H1 down to A275 to H275. I select all of it, Copy, go into the Sheet2 tab and select A1, Paste Special -> Transpose and it give me the following error message:
    The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of the following:
    - Click a single cell, and then paste.
    - Select a rectangle that's the same size and shape, and then paste.
    For the life of me, I can't figure out why it's not working! I have done this many times with other spreadsheets. Has anyone ever experienced this? If so, were you able to resolve it and how?

    Many Thanks,
    Mike

  2. #2
    New Member
    Join Date
    Mar 2007
    Location
    Sarnia, Ontario
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Of course, AFTER I post the question, I figured it out.

    It's not working because there is not enough room TO transpose all of it because Excel only goes from cells A1 to IV1. This happens to be 19 short of what I want to paste. Go figure!

    Thanks anyway!

  3. #3
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    37,991
    Post Thanks / Like
    Mentioned
    62 Post(s)
    Tagged
    12 Thread(s)

    Default

    Of course, AFTER I post the question, I figured it out.

    It's not working because there is not enough room TO transpose all of it because Excel only goes from cells A1 to IV1. This happens to be 19 short of what I want to paste. Go figure!

    Thanks anyway!
    Upgrade to Excel 2007... 16,384 columns, see here:
    http://office.microsoft.com/en-us/ex...ksheetWorkbook
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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