View Single Post
  #7   Report Post  
pchuk815 pchuk815 is offline
Junior Member
 
Posts: 1
Default

Quote:
Originally Posted by SusanW View Post
At the bottom of your Excel Sheet you may find a menu bar that starts to your
left with the word "Ready." Look to the far right on the same bar and you
will see three small icons (1 = normal; 2 = page layout; 3 = page break
view). To correct the problem, make sure that you are on "normal." Your
problem will go away. This solution is, however, spreadsheet related and not
universal for the program, so you may have to correct each spreadsheet where
the problem exists.

"ladaigle" wrote:

I have run in to an odd problem that is difficult to duplicate. When working
in excel, as you click between different cells, it randomly selects multiple
cells. For example, if I click on an individual cell it highlights that cell
plus two to the right (or two to the top/bottom). Tried several solutions
posted on the web but nothing seems to resolve the root of the problem.

Tried:

1. Try tapping the wheel of scroll mouse, if applicable.
2. Try changing the page view from Page Layout to any other View option:
View tab Normal
3. Close the spreadsheet, open again and see if behavior still exists.
4. Close Excel, open the spreadsheet and see if behavior still exists.
5. If cell still selects multiple cells, up keyboard up/down/left/right
arrows to navigate away and then back to cell, then click in the formula bar
to edit
6. If it says EXT or Extend Selection in the bottom left corner of Excel,
then it is in Extended mode - try tapping the F8 key once
7. Try zooming out then clicking the cell selection again: View tab Zoom
Edit % in Custom field Click OK

It is also impossible to €śmake this happen€ť. It usually occurs randomly.

Does MS recognize this as a problem?

I'm able to replicate this problem identically. Change page orientation to landscape, view to layout, zoom to 90% - click on any cell and it highlights multiple. Works every time.

Easiest fix is to either:

A) Change the view to either Page Break or Normal
B) Change Zoom level - I've found that you need to go atleast 3%+/- to solve it (i.e. 93% or 87%)