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

    Copying and pasing multiple cells (2000)

    On trying to copy and paste multiple cells l appear to be getting an error messgae, see attachement.

    I have tried various methods to do this but no luck,i.e using shift.
    I was told this in a previous posting.

    Any help would be appreciated.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Copying and pasing multiple cells (2000)

    You asked this identical question in <post:=567,482>post 567,482</post:> ...

    I presume (you do not show the row numbers) that the list has hidden rows or is filtered. This makes multiple selections.

    Steve

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

    Re: Copying and pasing multiple cells (2000)

    I am sorry l am not sure what you mean? please can you explain a bit more clearly.

  4. #4
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying and pasing multiple cells (2000)

    If some of the rows (or columns) in your spreadsheet are hidden, and you then select a range that includes some of the hidden cells, you're actually selecting the visible cells only. That means that there's a gap between the beginning of your selection and the end; as a result, you've selected more than one continuous area - a multiple selection.
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

Posting Permissions

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