show all view in Excel 2007

S

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?
 
G

Gordon

shan88 said:
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?
Click to expand...


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