Auto Filter not working?
I have a workbook where the autofilter does not seem to work. Usualy it is a
merged cell, but I have tried one column and mult sheets. I can copy this to another workbook and it will work. Any clue why autofilter would not work? (it is greyed out) |
Auto Filter not working?
Ok, got it figured out. I did not have the sheet protected or choosing mult
sheets. It turned out that the workbook had in the Tools/Options View Tab the "Hide All" in the objects. Once I did Show All, then my data/Autofilter became un-gray thanks "Don" wrote: I have a workbook where the autofilter does not seem to work. Usualy it is a merged cell, but I have tried one column and mult sheets. I can copy this to another workbook and it will work. Any clue why autofilter would not work? (it is greyed out) |
All times are GMT +1. The time now is 11:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com