Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AFTER 8 SEC ON SPACEBAR I GOT A FILTER?DELETE IT?
I was in an xcel work sheet and, while thinking kept my finger on the space
bar for than eight seconds. A pop-up showed stating I had invoked a "filter". Now I cannot get rid of the "filter. For example, when I click on any box other than, say, A1 the entire group of boxes is highlighted. Even when I get out of the worksheet and start a brand new worksheet the same thing occurs. How do I get rid of this "filter. Attempts to work with Microsoft's suggestions have failed as I can never see a highlighted "clear" for the data boxes. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AFTER 8 SEC ON SPACEBAR I GOT A FILTER?DELETE IT?
It sounds like you toggled a windows accessibility option.
Go to windows control panel|Accessibility options|Keyboard tab Uncheck the Filterkeys. As an aside, you may like to turn on the ToggleKeys option. You'll hear a beep if you hit the caps lock, num lock or scroll lock. It can be enough to stop typos. Carl wrote: I was in an xcel work sheet and, while thinking kept my finger on the space bar for than eight seconds. A pop-up showed stating I had invoked a "filter". Now I cannot get rid of the "filter. For example, when I click on any box other than, say, A1 the entire group of boxes is highlighted. Even when I get out of the worksheet and start a brand new worksheet the same thing occurs. How do I get rid of this "filter. Attempts to work with Microsoft's suggestions have failed as I can never see a highlighted "clear" for the data boxes. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
AFTER 8 SEC ON SPACEBAR I GOT A FILTER?DELETE IT?
In Vista you find it here
Control Panel\Ease of Access\Ease of Access Center Make the keyboard easier to use -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... It sounds like you toggled a windows accessibility option. Go to windows control panel|Accessibility options|Keyboard tab Uncheck the Filterkeys. As an aside, you may like to turn on the ToggleKeys option. You'll hear a beep if you hit the caps lock, num lock or scroll lock. It can be enough to stop typos. Carl wrote: I was in an xcel work sheet and, while thinking kept my finger on the space bar for than eight seconds. A pop-up showed stating I had invoked a "filter". Now I cannot get rid of the "filter. For example, when I click on any box other than, say, A1 the entire group of boxes is highlighted. Even when I get out of the worksheet and start a brand new worksheet the same thing occurs. How do I get rid of this "filter. Attempts to work with Microsoft's suggestions have failed as I can never see a highlighted "clear" for the data boxes. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter list and delete | Excel Discussion (Misc queries) | |||
Delete rows in filter view | Excel Worksheet Functions | |||
Spacebar to tab | Excel Discussion (Misc queries) | |||
filter and delete | Excel Worksheet Functions | |||
Fastest Way to Filter/Delete | Excel Worksheet Functions |