MSFN is made available via donations, subscriptions and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, register and become a site sponsor/subscriber and ads will be disabled automatically.

Sort & Filter grayed out

Recommended Posts

I have a table with A-G columns and 20 rows. If I do not select column A then the "Sort & Filter" is enable. The "Format as Table" also works. As soon as I select column "A" with the rest of the columns then these two functions don't work anymore. It's disabled or grayed out. Any suggestion? I'm using Excel 2010.