ExcelBanter - Filter in Excel

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

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

- - Filter in Excel (https://www.excelbanter.com/excel-worksheet-functions/179858-filter-excel.html)

Joscaira

Filter in Excel

How do I remove a filter that is frozen?

Max

Filter in Excel

"Joscaira" wrote:
How do I remove a filter that is frozen?

Maybe the sheet is protected?
Try Tools Protection Unprotect sheet
Then re-protect it, but check "Use Autofilter" before clicking OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

All times are GMT +1. The time now is 10:26 PM.