ExcelBanter - Autofilter Problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Autofilter Problem (https://www.excelbanter.com/excel-discussion-misc-queries/256036-autofilter-problem.html)

oscar

Autofilter Problem

Autofilter Arrows disappeared from Excel Spreadsheet. If I go to Data /
Filter AutoFilter is checked but grayed (can not check / ucheck). Can anybody
help?

Thanks, Oscar.

Dave Peterson

Autofilter Problem

Make sure you're viewing objects.

In xl2003 menus:
Tools|options|view tab|Objects section|check View All

I'm sure xl2007 has a similar option.

Oscar wrote:

Autofilter Arrows disappeared from Excel Spreadsheet. If I go to Data /
Filter AutoFilter is checked but grayed (can not check / ucheck). Can anybody
help?

Thanks, Oscar.

--

Dave Peterson

GILBERT

Autofilter Problem

Is the row with the arrows perhaps hidden?

"Oscar" wrote:

Autofilter Arrows disappeared from Excel Spreadsheet. If I go to Data /
Filter AutoFilter is checked but grayed (can not check / ucheck). Can anybody
help?

Thanks, Oscar.

All times are GMT +1. The time now is 12:30 PM.