( Click here for full explanation of how to modify your Status Bar.) And it works about the way you’d expect it to. If you don’t see that on your Status Bar, simply right-click anywhere on it and make sure that feature has a check mark next to it. To me, the easiest way is to use the slider at the right hand end of the Status Bar: But, as it turned out, her problem was solved by adjusting the Zoom on her View in Excel.Ĭhanging the Zoom is easy, and there are several ways to do it. Zoom Sliderīased on this reader’s description of her problem, I had assumed she had stumbled across Extend Selection Mode. That’ll turn it off and return your mouse and arrow keys to normal function. If you notice some weird selection behavior going on with your mouse in Excel, take a look at the Status Bar - you might see something toward the left end that says “Extend Selection.” Even if you don’t, turning the selection mode off is easy. Extend Selection changes the behavior of the mouse and arrow keys to enable a user to more easily select multiple cells. This basically means that your first mouse click will define the start of your selection and your second mouse click will define the end of it. And not one but two possible solutions presented themselves.Īpparently, according to this Microsoft Answers entry, if you press the F8 key, you’re toggled into something called Extend Selection Mode. So what did I do? I went to Microsoft Answers ( ) and did a little search. I personally had never run across that particular problem, so I had no solution off the top of my head. Well, this was certainly a new one for me. It was as if her mouse cursor had a mind of its own! In other words, she couldn’t select a single cell or just one row in the spreadsheet. When in a spreadsheet and I click on a line it selects at least four lines.
0 kommentar(er)
