You must be in the edit mode. Click anywhere on the worksheet to get out of
edit mode.

Let me know if this solves your problem.

There are other ways to find duplicates...

"Zack" wrote:

I am trying to remove duplicate records but the Advanced Filter option is
grayed out. What is the trick to have that option viable?