+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Excel - Choosing Two Cells in Technical; ...
  1. #1

    garethedmondson's Avatar
    Join Date
    Oct 2008
    Gowerton, Swansea
    Thank Post
    Thanked 325 Times in 193 Posts
    Blog Entries
    Rep Power

    Excel - Choosing Two Cells

    Really strange one here, but when some pupils click on a cell in Excel 2007 the cell to the immediate right is also chosen. I've tried to paste the screenshot here:

    Pupil has chosen the £5.70 but the cell to the right has also been chosen for some strange reason. Happens on whichever computer she is using at the time. Could it be anything in the file? The cells are not merged.



  2. #2
    themightymrp's Avatar
    Join Date
    Dec 2009
    Leeds, West Yorkshire
    Thank Post
    Thanked 236 Times in 204 Posts
    Rep Power
    Is the excel sheet running maximised on screen? I've heard of a couple of occasions where this has thrown out the accuracy of the mouse pointer in Excel. Also, when you select a cell try doing a Ctrl+Z undo immediately afterwards. If it now only selects the cell you actually clicked on it could be a setting somewhere in the worksheet as it suggests another command is running.
    Damned if I know what though!!???

  3. #3

    Hightower's Avatar
    Join Date
    Jun 2008
    Cloud 9
    Thank Post
    Thanked 690 Times in 444 Posts
    Rep Power
    If the cells are not merged, it could be that the extend mode is currently turned on. Take a look at the status bar at the bottom of the worksheet. If you see the letters EXT in bold, then extend mode is active. Double-click the EXT letters to turn it off or simply press F8. (When Excel is in extend mode, one end of a selection is "anchored" and the selection extends from there to where you click or move next.)

    Source: Selecting Multiple Cells by Mistake (Microsoft Excel)

+ Post New Thread

Similar Threads

  1. calculating cells without draging selection
    By tinmanjo in forum Office Software
    Replies: 3
    Last Post: 1st July 2010, 12:01 PM
  2. EXCEL - Recording survey details in excel - Easiest way
    By reecec in forum Office Software
    Replies: 2
    Last Post: 28th April 2010, 09:16 PM
  3. Replies: 1
    Last Post: 22nd December 2009, 06:05 PM
  4. VB code to colour cells in a word table
    By park_bench in forum Coding
    Replies: 4
    Last Post: 30th June 2008, 09:52 AM
  5. Excel Not Recognizing Cells of Equal Value
    By G_Money in forum Windows
    Replies: 2
    Last Post: 21st June 2007, 09:33 AM

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