| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how get i see above 1000 date in auto filter?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how get i see above 1000 date in auto filter?
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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
