Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locked somehow
A coworker was working on a worksheet in excel when she accidentally held
down a key too long and something came up about the filter and she clicked cancel. Ever since that point, it you try to click on another cell besides the one it is on, it will just highlight all of the ones in between and wont let you type certain things into that one cell, nor can you scroll anywhere or pull up another sheet in that file. What can I do to fix this problem so that it is back to normal? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locked somehow
Shonda,
Sounds like she is in EXTEND mode - try pressing F* to toggle out of that mode. F8 - Turn extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection. HTH, Bernie MS Excel MVP "Shonda" wrote in message ... A coworker was working on a worksheet in excel when she accidentally held down a key too long and something came up about the filter and she clicked cancel. Ever since that point, it you try to click on another cell besides the one it is on, it will just highlight all of the ones in between and wont let you type certain things into that one cell, nor can you scroll anywhere or pull up another sheet in that file. What can I do to fix this problem so that it is back to normal? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locked somehow
Do you see EXT on the status bar?
Hit F8 to cancel that "extended mode" Gord Dibben MS Excel MVP On Thu, 25 Oct 2007 07:00:01 -0700, Shonda wrote: A coworker was working on a worksheet in excel when she accidentally held down a key too long and something came up about the filter and she clicked cancel. Ever since that point, it you try to click on another cell besides the one it is on, it will just highlight all of the ones in between and wont let you type certain things into that one cell, nor can you scroll anywhere or pull up another sheet in that file. What can I do to fix this problem so that it is back to normal? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOCKED | Excel Discussion (Misc queries) | |||
Locked for editing | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Completely Locked Out | Excel Discussion (Misc queries) | |||
mouse locked | Excel Discussion (Misc queries) |