Results 1 to 5 of 5
  1. #1
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts
    In Excel 2003, I dragged with the mouse to select a group of cells, then went to Format Cell to change the background color. I then noticed that apparently a cell that was 6 cells away from the ones I was selecting had also been selected and its background color changed. I did a few more selections and noticed it happening again. Is there something about the way a spreadsheet is created that can cause this to happen? How can I prevent this in the future?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Did you happen to hold down the Ctrl key while selecting the cells?

  3. #3
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts
    Yes, I did. I was selecting a few non-contiguous areas.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    That probably explains it - if you start selecting with Ctrl held down, the cell (or range) that was selected when you started is included.

  5. #5
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts
    OK I just did another sheet, per your direction. Working well now, so I will assume that was it.

    Thanks

Posting Permissions

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