| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i filter a list greater than 1000 rows
I have used Excel spreadsheet as a database for recording Individual ID and
comparative performance of a cattle herd to great advantage utilising Data Filter for some time. Now I cannot filter the newest entries, am I limited to a set number of rows? Perhaps I have overlooked something simple, Any solutions or suggestions Please! Ed |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i filter a list greater than 1000 rows
Debra Dalgleish has some notes he
http://www.contextures.com/xlautofilter02.html#Limits which give some tips on how to overcome these limitations in Excel filtering. Hope this helps. Pete On Apr 29, 8:57*am, kambara1 wrote: I have used Excel spreadsheet as a database for recording Individual ID and comparative performance of a cattle herd to great advantage utilising Data Filter for some time. Now I cannot filter the newest entries, am I limited to a set number of rows? Perhaps I have overlooked something simple, Any solutions or suggestions Please! Ed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how get i see above 1000 date in auto filter? | Excel Discussion (Misc queries) | |||
| 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 | |||
| How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
| Why does excel not see more than 1000 lines in filter mode? | Excel Discussion (Misc queries) | |||
Linear Mode
