| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filters
I have a spreadsheet with 6000 rows. When ever I add a filter, it does not
filter everything. I can determine this because I take the filter off and do a control find for the item. Excel then locates the cell information by using the Control Find. I put the Filter back on and I can not find the cell in that manner. Why does excel do this? How do I get around it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filters
Filter is only good up to 1000 rows. You may use Pivot instead
"Probber" wrote: I have a spreadsheet with 6000 rows. When ever I add a filter, it does not filter everything. I can determine this because I take the filter off and do a control find for the item. Excel then locates the cell information by using the Control Find. I put the Filter back on and I can not find the cell in that manner. Why does excel do this? How do I get around it? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filters
You can filter as many rows as you need (64k or 1MB).
There is a limit of 1000 unique entries that appear in the dropdown list--but you can use Custom to filter to show what you want. Teethless mama wrote: Filter is only good up to 1000 rows. You may use Pivot instead "Probber" wrote: I have a spreadsheet with 6000 rows. When ever I add a filter, it does not filter everything. I can determine this because I take the filter off and do a control find for the item. Excel then locates the cell information by using the Control Find. I put the Filter back on and I can not find the cell in that manner. Why does excel do this? How do I get around it? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filters
Make sure you select the range explicitly--don't let excel guess at the range.
If there are gaps (empty rows or columns), excel may not filter the range that you want. Probber wrote: I have a spreadsheet with 6000 rows. When ever I add a filter, it does not filter everything. I can determine this because I take the filter off and do a control find for the item. Excel then locates the cell information by using the Control Find. I put the Filter back on and I can not find the cell in that manner. Why does excel do this? How do I get around it? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy with filters but not copy the filters in the middle? | Excel Discussion (Misc queries) | |||
| Macro freezes after using Filters. | Excel Discussion (Misc queries) | |||
| Excel should have a drop down box that shows all the filters on | Excel Worksheet Functions | |||
| Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
| Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
Linear Mode
