Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here's some notes from Debra Dalgeish:
http://www.contextures.com/xlautofilter02.html#Limits which give tips on how to overcome these limitations - basically, filter on other columns first to reduce the number of data values that you want to filter on. Hope this helps. Pete On Jan 17, 11:53*am, sanjay kumar das <sanjay kumar wrote: i have facing a problem in excell auto filter option, i have over 1000 data when i filter on SR no. and filter on it there is showing only 1000 SR no. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To filter for 100 documents out of 1000 | Excel Discussion (Misc queries) | |||
How change maximal value in excel for filter (1000) ? | New Users to Excel | |||
in excel, want data to change auto from 1000 to one thousand | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Why does excel not see more than 1000 lines in filter mode? | Excel Discussion (Misc queries) |