Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
catherine47
 
Posts: n/a
Default 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?



  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel auto formats cells with numbers - Can it be disabled? Jeromey Setting up and Configuration of Excel 1 May 21st 06 01:17 AM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
copy & paste spreadsheet cells from excel to outlook to excel mismarple Excel Discussion (Misc queries) 1 September 20th 05 11:16 PM
How to partially lock the cells in Excel? Locking cels in Excel Excel Discussion (Misc queries) 1 September 19th 05 02:21 PM
Can I lock info in Excel 2003 and users in Excel 2000 enter info? Mimmsan Excel Discussion (Misc queries) 1 September 8th 05 12:12 AM


All times are GMT +1. The time now is 08:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"