Posted to microsoft.public.excel.worksheet.functions

TomCat

external usenet poster

Posts: 34

AutoFilter: custom filter hides all

I have a column that contains number/letter format 100ABC, 101DEF, etc. When
I do a custom filter to show all the cells that contain 100, etc., the entire
column hides. How do I get it to show the cells I want to see?
Thanks....TomCat

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How do I filter for a blank cell, using custom autofilter	Bee Jay Are Es Ay	Excel Discussion (Misc queries)	3	April 3rd 23 07:00 PM
Autofilter Hides All...	TomCat	Excel Worksheet Functions	1	June 8th 09 12:43 PM
custom autofilter	mto	Excel Worksheet Functions	3	June 2nd 07 01:07 AM
saving autofiltercustom filter settings	Edwin199976	Excel Worksheet Functions	2	December 13th 06 06:52 PM
Shortcut for Filter- Custom Autofilter	Eileen	Excel Discussion (Misc queries)	2	November 27th 04 01:09 PM

All times are GMT +1. The time now is 06:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us