ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   turn off filter (https://www.excelbanter.com/excel-worksheet-functions/18674-turn-off-filter.html)

Kathy in Chicago

turn off filter
 
I enabled a filter on a spreadsheet. Now I want to turn it off and restore
the sheet to its original condition. Can't figure out how to do it.

Max

Click Data Filter Autofilter to toggle off
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Kathy in Chicago" <Kathy in wrote in
message ...
I enabled a filter on a spreadsheet. Now I want to turn it off and

restore
the sheet to its original condition. Can't figure out how to do it.





All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com