Hello Everyone,

I'm running Excel 2011 for Mac, and I'm running into a formatting issue when I use the auto-filter function.

First, I'll point out that I've formatted all but one row of the worksheet to "wrap text." This formatting works until I filter by one of the columns. If I look at the cell formatting after I've used auto-filter, it will still show that I've selected "wrap text," even though it is not actually wrapping the text. It is not until I uncheck "wrap text," and then check it again that it will format the cells properly.

If you have any insight on how I can remedy this issue, I would greatly appreciate it! I hate having to reformat the entire worksheet each time I filter by a column.

Thank you in advance!