Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to insert row or delete while the auto filter is turn on?
it's very inconvinient for me to turn of the auto filter each time when i
tried to insert or delete row frm my excel workbook.then i need to turn the auto filter on again since i need to sort my data. Is there any way to solve my problem? |
#2
|
|||
|
|||
You can delete as many rows as you like when autofilter is enabled. And I've
never had trouble sorting rows with autofilter enabled. But if you meant you have to turn off autofilter when you want to insert/delete columns, then you could upgrade to xl2002/xl2003. You can delete columns from an autofilter range in those versions. catherine wrote: it's very inconvinient for me to turn of the auto filter each time when i tried to insert or delete row frm my excel workbook.then i need to turn the auto filter on again since i need to sort my data. Is there any way to solve my problem? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |