ExcelBanter - The clear filter from a a heading cell is grey out

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - The clear filter from a a heading cell is grey out (https://www.excelbanter.com/excel-worksheet-functions/243452-clear-filter-heading-cell-grey-out.html)

Mark

The clear filter from a a heading cell is grey out

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

Gord Dibben

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

Mark

The clear filter from a a heading cell is grey out

I have check these out but unfortunately they did not apply....Mark

"Gord Dibben" wrote:

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

All times are GMT +1. The time now is 09:45 PM.