URGENT !! Auto Filter

[Guest]

I have an excel from someone. I applied auto filter, but I am not able to see
the filter in the spread sheet. I am not sure if there is any special
protection the work sheet that prohibits use of a filter. Please help. It's
very urgent.

 

[gjcase]

If the sheet is protected, it may be locked to prevent users from usin
autofilter. Use Tools/Protection/Unprotect Sheet. If Unprotect is a
option, you should be good. If there is a password and you cannoo
obtain it from the person who sent it to you, you can select all dat
on the sheet and copy it to a new workbook where you can filter th
data. Alternatively, there are password cracking utilities available.

---Glen