show all view in Excel 2007
 

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?

show all view in Excel 2007
 

"shan88" wrote in message
...
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?

show all view in Excel 2007
 

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

"Gordon" wrote:

"shan88" wrote in message
...
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?

show all view in Excel 2007
 

"shan88" wrote in message
...
Thank you Gordon. It's so simple once you know where to find it.

"Gordon" wrote:

"shan88" wrote in message
...
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?




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