ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   My autofilter is dimmed in one worksheet only in Excel 2003 how d. (https://www.excelbanter.com/excel-worksheet-functions/113497-my-autofilter-dimmed-one-worksheet-only-excel-2003-how-d.html)

LarrW

My autofilter is dimmed in one worksheet only in Excel 2003 how d.
 
I have a Excel 2003 file with multiple sheet and I am unable to autofilter,
it is dimmed and I have been unable to activate it .

ducky

My autofilter is dimmed in one worksheet only in Excel 2003 how d.
 


On Oct 9, 12:26 pm, LarrW wrote:
I have a Excel 2003 file with multiple sheet and I am unable to autofilter,
it is dimmed and I have been unable to activate it .


Sounds like your sheet is protected. You can unprotect it by clicking
toolsprotection. if there is a password set, you'll need to have that
as well

HTH

AR


LarrW

My autofilter is dimmed in one worksheet only in Excel 2003 ho
 
protection is not on

"ducky" wrote:



On Oct 9, 12:26 pm, LarrW wrote:
I have a Excel 2003 file with multiple sheet and I am unable to autofilter,
it is dimmed and I have been unable to activate it .


Sounds like your sheet is protected. You can unprotect it by clicking
toolsprotection. if there is a password set, you'll need to have that
as well

HTH

AR



Debra Dalgleish

My autofilter is dimmed in one worksheet only in Excel 2003 ho
 
If you have more than one sheet selected, AutoFilter won't be available,
and [Group] will appear at the end of the file name in the Title Bar.

LarrW wrote:
protection is not on

"ducky" wrote:



On Oct 9, 12:26 pm, LarrW wrote:

I have a Excel 2003 file with multiple sheet and I am unable to autofilter,
it is dimmed and I have been unable to activate it .


Sounds like your sheet is protected. You can unprotect it by clicking
toolsprotection. if there is a password set, you'll need to have that
as well

HTH

AR





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 11:14 AM.

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