show all view in Excel 2007

[shan88]

In Excel 2003 there was a Show All View button that would re-set the view
after filtering. I do not see a comparable button in 2007.

Can anyone help with this?

 

[Gordon]

In Excel 2003 there was a Show All View button that would re-set the view
after filtering. I do not see a comparable button in 2007.

Can anyone help with this?

On the Data tab in the Sort and Filter box there's a "clear" button?

 

[shan88]

Thank you Gordon. It's so simple once you know where to find it.

 

[Gordon]

Thank you Gordon. It's so simple once you know where to find it.

YW! I wasn't /quite/ sure whether that is what it did... ;-)