Multiple cells are selected in Microsoft Excel with single click

[Rounder1]

I am fairly new to Excel. I just created a worksheet and now all of a sudden every time I click on the page, it highlights/selects multiple cells all at once. How do I turn this off. Did I push a button I wasn't aware of. Thanks.

[GaganjyotTechie]

Are you using a laptop. Perhaps it's your laptop mouse settings. I don't know of any features in Excel that will allow you to select multiple cells based solely off a mouse click. Would be interested to know if Excel does do that.

[Rounder1]

Do you mean that the selection is anchored on one cell and select up to the new cursor position? If so does it say EXT at the bottom of the screen? If so press the function key F8 to come out of Extended mode. If there is no EXT showing try to *gently* tap the wheel of the mouse several times.

[Bontu]

I tried to find information on the same and found that issue can be also related to your system hardware. Check your drivers. An easy fix can be done to this by exiting excel and then re-opening it back again. Avoid working under page layout view. Because the issue comes only under page layout view. Switch to normal view and then try back. Ensure that shift key is not stucked on your keyboard or by mistake sticky keys are not activated, you can find the settings for that in Mouse settings under control panel.