Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying and pasting multiple cells (2000)

    I am trying to copy and paste multiple cells but appear to be getting an error, can you tell me the reason for the error.
    As sometimes the copying and passting works , other times is does not.
    see screenshot.
    Any help would be appreciated.

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

    Re: Copying and pasting multiple cells (2000)

    The error message means precisely what it says. If you select multiple areas using the Ctrl key, copy to the clipboard, then select other multiple areas using the Ctrl key, you'll get this error message. If you select multiple cells in a single area using the mouse or the Shift key, there should be no problem.

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copying and pasting multiple cells (2000)

    Further to Hans' response; I am often brought up short when I lose sight of the fact that my sheet is filtered, and there are hidden, unselected cells within what appears to be a single, continuous selected block of cells.
    Regards
    Don

Posting Permissions

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