Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 361
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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
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
Filter list and delete OfficeNDN Excel Discussion (Misc queries) 4 September 11th 06 04:08 PM
Delete rows in filter view Dakota Excel Worksheet Functions 1 March 22nd 06 02:50 PM
Spacebar to tab famdamly Excel Discussion (Misc queries) 1 February 27th 06 12:50 AM
filter and delete Jordan Excel Worksheet Functions 1 July 7th 05 07:18 PM
Fastest Way to Filter/Delete SyrHoop Excel Worksheet Functions 6 November 10th 04 06:33 PM


All times are GMT +1. The time now is 03:10 PM.

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"