show all view in Excel 2007

  • Thread starter Thread starter shan88
  • Start date Start date
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?
 
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?
 
shan88 said:
Thank you Gordon. It's so simple once you know where to find it.
Click to expand...


YW! I wasn't /quite/ sure whether that is what it did... ;-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add-Ins for iSeries Access Data Transfer in Excel 2007 0
Flowchart toolbars in Excel 07 2
Can't view Google Maps in 3D anymore? Here's the fix. 2
Have Excel 2007 but need to open files from Excel 2003 1
Insert function 3
how do you show the task pane in office 2007 1
Access Instead of 31 rows for March, the view shows 62 records.... 0
Color Scale Issue 2007 to 2003 1

Back
Top