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

C

catherine47

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - using shift key 1
How can I remove the previous lock cells and keep the new ones. 2
How do I turn scroll lock off (2007 excel)? No scroll lock key 1
Highlighting cells - Mouse sticking?? 2
How do I add cells by highlighting them? 2
How do I shift cells down in Excel? 1
Out of control scroll lock?? 2
HOW DO I LOCK CERTAIN CELLS 2

Top