| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter was not recognizing rows after row 999
My spreadsheet is about 4000 rows. applied autofilter and it was not
recognizing data below 999 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofilter was not recognizing rows after row 999
There is a limit of 1000 entries that the Autofilter can show in versions
prior to 2007. The limit in XL2007 is 10,000. Regards, Fred. "mafeeheda" wrote in message ... My spreadsheet is about 4000 rows. applied autofilter and it was not recognizing data below 999 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofilter was not recognizing rows after row 999
Advice at http://www.contextures.com/xlautofilter02.html#Limits
-- David Biddulph "Fred Smith" wrote in message ... There is a limit of 1000 entries that the Autofilter can show in versions prior to 2007. The limit in XL2007 is 10,000. "mafeeheda" wrote in message ... My spreadsheet is about 4000 rows. applied autofilter and it was not recognizing data below 999 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recognizing sets of rows | Excel Discussion (Misc queries) | |||
| Autofilter on rows instead of columns | Excel Worksheet Functions | |||
| Is there a way I can autofilter columns instead of rows | Excel Worksheet Functions | |||
| AutoFilter and adding new rows | Excel Discussion (Misc queries) | |||
| Why does the Sort function stop recognizing Header Rows? | Excel Worksheet Functions | |||
Linear Mode
