How do I change the display options in the status bar of MS Excel
 

Bottom left corner of the viewable page use to display number of rows in the
worksheet. Now it displays "Ready" or "Filter Mode" and none of the options
available on the right-clicked menu.

How can I change it back?

How do I change the display options in the status bar of MS Excel
 

Debra Dalgleish explains it:
http://contextures.com/xlautofilter02.html#Count

Baffled wrote:

Bottom left corner of the viewable page use to display number of rows in the
worksheet. Now it displays "Ready" or "Filter Mode" and none of the options
available on the right-clicked menu.

How can I change it back?

--

Dave Peterson