View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default The clear filter from a a heading cell is grey out

Possible problems...............

Sheet is protected.

Multiple sheets are selected.

The workbook is shared.


Gord Dibben MS Excel MVP

On Tue, 22 Sep 2009 16:38:01 -0700, Mark
wrote:

I'm using excel 2007 an attempting to remove a filter from a heading cell.
however it is greyed out, can this be rectified....Thanks Mark