+ Post New Thread
Results 1 to 11 of 11
Office Software Thread, Excel 2007 Strange problem in Technical; Hello got a problem with Excel were by if you select data from say A2-A7 then hold down the ctrl ...
  1. #1
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    580
    Thank Post
    113
    Thanked 25 Times in 22 Posts
    Rep Power
    19

    Excel 2007 Strange problem

    Hello

    got a problem with Excel were by if you select data from say A2-A7 then hold down the ctrl key and select B2-B7 the B cell dont get selected, I have tried showing it in a screen shot below

    excel error.JPG

  2. #2


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,463
    Thank Post
    1,462
    Thanked 892 Times in 573 Posts
    Rep Power
    647
    Works ok on my mine.

  3. Thanks to laserblazer from:

    tech_guy (13th June 2011)

  4. #3
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    580
    Thank Post
    113
    Thanked 25 Times in 22 Posts
    Rep Power
    19
    Thanks for that mate lol

  5. #4
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Sorry what doesnt it select? the B cells look selected or do you mean the B2 cell (that also looks selected)?

  6. #5

    Join Date
    Mar 2011
    Location
    Enfield
    Posts
    2
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I think you'll find it is selected. It's a different shade only to indicate it's the active cell.

  7. #6
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    580
    Thank Post
    113
    Thanked 25 Times in 22 Posts
    Rep Power
    19
    problem is it doesnt as when you try to do a graph based on those cells the graph only picks up for set of cells highlighed

  8. #7
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    So if you copy and paste it only copies (in this case) A2-A7 and B3-B7?

  9. #8
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    580
    Thank Post
    113
    Thanked 25 Times in 22 Posts
    Rep Power
    19
    not trying to copy and paste just highlight the cells,

    so trying to highligh cells eg a1 to a10 then i hit the control key to highlight my next group of cells b1-b10 and it doesnt highligh them

  10. #9
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Yeah i get that but i was just see if its affecting something else such as copy and paste. Can i confirm what isnt highlighted because on your screenshot it all looks highlighted so is it the B1-B10 cells thats not hightlighted/selected and what happens when you try to copy and paste?

  11. #10


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,463
    Thank Post
    1,462
    Thanked 892 Times in 573 Posts
    Rep Power
    647
    Quote Originally Posted by ful56_uk View Post
    problem is it doesnt as when you try to do a graph based on those cells the graph only picks up for set of cells highlighed
    I did figure that's what you were trying to do, so I tried a graph and I had both sets of data. What happens if you select two adjacent columns so you don't have to use ctrl?

  12. #11
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    580
    Thank Post
    113
    Thanked 25 Times in 22 Posts
    Rep Power
    19
    works fine that way but if they have a sheet that has 10 columns and they only want 1,4,9 then you get the problem. really strange this, does it as a admin user and student and even rebuilt the work station



SHARE:
+ Post New Thread

Similar Threads

  1. Strange Excel Problem
    By Jon in forum Windows
    Replies: 14
    Last Post: 14th July 2011, 05:55 PM
  2. [MS Office - 2007] Strange Word 2007 problem.
    By Jobos in forum Office Software
    Replies: 0
    Last Post: 4th November 2009, 03:19 PM
  3. [MS Office - 2007] Excel 2007 problem
    By nc- in forum Office Software
    Replies: 4
    Last Post: 18th March 2009, 05:14 PM
  4. [MS Office - 2007] Strange behavior opening excel 2007
    By imiddleton25 in forum Office Software
    Replies: 3
    Last Post: 22nd September 2008, 11:59 PM
  5. Excel 2007
    By wesleyw in forum Windows
    Replies: 0
    Last Post: 22nd June 2007, 04:31 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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