how do i remove shift lock (highlighting cells) from excel?
 

Have what I think is a shift lock issue with excel. Think this is a function
i have inadvertedly turned on, perhaps whilst holding down shift key for too
long whilst typing. Right clicking/double clicking won't remove it.

Shift to create a capital no longer works.
When I tab it goes left instead of right.
Clicking with mouse anywhere highlights all cells in the area.
Trying to enter numbers enters their symbols instead.

Does anyone know what this function is? How i switch it off?

how do i remove shift lock (highlighting cells) from excel?
 

might be sticky keys.


tap the shift key 5 times and turn it off
--
Gary's Student


"catherine47" wrote:

Have what I think is a shift lock issue with excel. Think this is a function
i have inadvertedly turned on, perhaps whilst holding down shift key for too
long whilst typing. Right clicking/double clicking won't remove it.

Shift to create a capital no longer works.
When I tab it goes left instead of right.
Clicking with mouse anywhere highlights all cells in the area.
Trying to enter numbers enters their symbols instead.

Does anyone know what this function is? How i switch it off?

how do i remove shift lock (highlighting cells) from excel?
 

Your Shift key is definitely stuck.

Gently tap on a few times to see if can get unstuck.

If not physically stuck, does a re-boot of computer make any difference?

Have you tried another keyboard?


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 04:19:01 -0700, catherine47
wrote:

Have what I think is a shift lock issue with excel. Think this is a function
i have inadvertedly turned on, perhaps whilst holding down shift key for too
long whilst typing. Right clicking/double clicking won't remove it.

Shift to create a capital no longer works.
When I tab it goes left instead of right.
Clicking with mouse anywhere highlights all cells in the area.
Trying to enter numbers enters their symbols instead.

Does anyone know what this function is? How i switch it off?