| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto-filter image
I turned Auto-filter OFF but the Auto-filter drop-down arrow image remains in
random columns. The AUto-filter does not function because Auto-filter is turned off and that is fine but I need to get rid of the drop-down arrow images. any ideas???? thanks in advance! jane |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto-filter image
Click the '1' on the upper-left hand side of your screen (entire row is
selected). Then click Data Filter AutoFilter. This will uncheck the AutoFilter. Regards, Ryan-- -- RyGuy "jane" wrote: I turned Auto-filter OFF but the Auto-filter drop-down arrow image remains in random columns. The AUto-filter does not function because Auto-filter is turned off and that is fine but I need to get rid of the drop-down arrow images. any ideas???? thanks in advance! jane |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto-filter image
I did that to turn Auto-filter off but the drop-down arrow image remains.
"ryguy7272" wrote: Click the '1' on the upper-left hand side of your screen (entire row is selected). Then click Data Filter AutoFilter. This will uncheck the AutoFilter. Regards, Ryan-- -- RyGuy "jane" wrote: I turned Auto-filter OFF but the Auto-filter drop-down arrow image remains in random columns. The AUto-filter does not function because Auto-filter is turned off and that is fine but I need to get rid of the drop-down arrow images. any ideas???? thanks in advance! jane |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto-filter image
Can you right-click on one of those arrows to select it? You may be looking
at objects. Run this code (found it on another post) to delete all 'objects' on your sheet: Sub DeleteObjects() Dim nType As Long Dim shp As Shape For Each shp In ActiveSheet.Shapes nType = shp.Type Select Case nType Case msoChart, msoTextBox ' inlcude "or anything else for that matter" not to delete Case Else shp.Delete End Select Next End Sub Regards, Ryan--- -- RyGuy "jane" wrote: I did that to turn Auto-filter off but the drop-down arrow image remains. "ryguy7272" wrote: Click the '1' on the upper-left hand side of your screen (entire row is selected). Then click Data Filter AutoFilter. This will uncheck the AutoFilter. Regards, Ryan-- -- RyGuy "jane" wrote: I turned Auto-filter OFF but the Auto-filter drop-down arrow image remains in random columns. The AUto-filter does not function because Auto-filter is turned off and that is fine but I need to get rid of the drop-down arrow images. any ideas???? thanks in advance! jane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
| Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
| auto resize when insert large image to excel | Excel Worksheet Functions | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| How to auto start a new Excel image or window when opening files | Setting up and Configuration of Excel | |||
Linear Mode
