Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    many sheets into one (XP 2003)

    I have a workbook of many sheets, and want to copy all the content into a single sheet in another workbook. The first sheet copy-and-pasted okay, but the second one gave an error about being different sizes. (I selected all cells using the top-left box above row 1) Is there another way to select all (non-blank) cells and then copy and paste into another sheet? thanks in advance
    frank

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: many sheets into one (XP 2003)

    Click in A1.
    Press Ctrl+Shift+End to select the rectangular range from A1 to the last filled cell.
    Copy and paste.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: many sheets into one (XP 2003)

    thanks - works great
    frank

Posting Permissions

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