Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 161
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 161
Default 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... ;-)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost view of spreadsheet EXCEL 2007 Anna Excel Discussion (Misc queries) 0 November 17th 07 10:01 AM
How do I get the classic view in Excel 2007 without an add-in? Mark Excel Discussion (Misc queries) 1 September 3rd 07 11:56 AM
How to name a view in Excel 2007? Gradster Excel Discussion (Misc queries) 1 June 13th 07 05:50 PM
How do I show my header in regular view on excel? Dudley New Users to Excel 3 April 30th 05 02:07 PM
Excel 2000: Options-View-Show-Windows in Taskbar resets everytime. Papa John Excel Discussion (Misc queries) 3 February 28th 05 11:59 AM


All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"