Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem viewing back the "Unfiltered range"
Hi,
When you use the AutoFilter command, AutoFilter arrows appear to the right of the column labels in the filtered range. Scenario: If you filter more than one cloumn, there are posibility that it becomes difficult to revert to Unfiltered range from filtered range. Therefore, I wish if an item by name "Unfilter range" is specified, then the user view the unfiltered range immediately, rather than manipulating the filter arrows again. Challa Prabhu ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem viewing back the "Unfiltered range"
I use the "Show All" from the filter menu & which I have placed on my toolbar
Saintsman "challa prabhu" wrote: Hi, When you use the AutoFilter command, AutoFilter arrows appear to the right of the column labels in the filtered range. Scenario: If you filter more than one cloumn, there are posibility that it becomes difficult to revert to Unfiltered range from filtered range. Therefore, I wish if an item by name "Unfilter range" is specified, then the user view the unfiltered range immediately, rather than manipulating the filter arrows again. Challa Prabhu ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem viewing back the "Unfiltered range"
Hi,
Thanks for your quick response. In Either case one has to go to Data- Filter+Show All or create a cutom tool bar add Show all command from the data category and place it the toolbar. For example, if I filter on a Name field and get 60 records, and changing other filed(s) would give another set of records, which could probabily be 5, After lot of filter across diferen column, I should come back to 60 when I press All. Challa Prabhu "Saintsman" wrote: I use the "Show All" from the filter menu & which I have placed on my toolbar Saintsman "challa prabhu" wrote: Hi, When you use the AutoFilter command, AutoFilter arrows appear to the right of the column labels in the filtered range. Scenario: If you filter more than one cloumn, there are posibility that it becomes difficult to revert to Unfiltered range from filtered range. Therefore, I wish if an item by name "Unfilter range" is specified, then the user view the unfiltered range immediately, rather than manipulating the filter arrows again. Challa Prabhu ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem viewing back the "Unfiltered range"
No need for custom toolbar - it is already there
customise your toolbar (right mouse on toolbar) Select Commands Select category Data & select then add Show All to Toolbar It is such an easy thing to do - simple explanation on the spreadsheet to let people know "challa prabhu" wrote: Hi, Thanks for your quick response. In Either case one has to go to Data- Filter+Show All or create a cutom tool bar add Show all command from the data category and place it the toolbar. For example, if I filter on a Name field and get 60 records, and changing other filed(s) would give another set of records, which could probabily be 5, After lot of filter across diferen column, I should come back to 60 when I press All. Challa Prabhu "Saintsman" wrote: I use the "Show All" from the filter menu & which I have placed on my toolbar Saintsman "challa prabhu" wrote: Hi, When you use the AutoFilter command, AutoFilter arrows appear to the right of the column labels in the filtered range. Scenario: If you filter more than one cloumn, there are posibility that it becomes difficult to revert to Unfiltered range from filtered range. Therefore, I wish if an item by name "Unfilter range" is specified, then the user view the unfiltered range immediately, rather than manipulating the filter arrows again. Challa Prabhu ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem viewing back the "Unfiltered range"
I had a similar problem. I found that you can recall filter criteria by
using custom views. Just filter to your heart's content, then save the result as a custom view--I included "Hidden rows" as part of the custom-view definition. After making changes to the filter, select the custom view to see the saved filter again! "Saintsman" wrote: No need for custom toolbar - it is already there customise your toolbar (right mouse on toolbar) Select Commands Select category Data & select then add Show All to Toolbar It is such an easy thing to do - simple explanation on the spreadsheet to let people know "challa prabhu" wrote: Hi, Thanks for your quick response. In Either case one has to go to Data- Filter+Show All or create a cutom tool bar add Show all command from the data category and place it the toolbar. For example, if I filter on a Name field and get 60 records, and changing other filed(s) would give another set of records, which could probabily be 5, After lot of filter across diferen column, I should come back to 60 when I press All. Challa Prabhu "Saintsman" wrote: I use the "Show All" from the filter menu & which I have placed on my toolbar Saintsman "challa prabhu" wrote: Hi, When you use the AutoFilter command, AutoFilter arrows appear to the right of the column labels in the filtered range. Scenario: If you filter more than one cloumn, there are posibility that it becomes difficult to revert to Unfiltered range from filtered range. Therefore, I wish if an item by name "Unfilter range" is specified, then the user view the unfiltered range immediately, rather than manipulating the filter arrows again. Challa Prabhu ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Use of "&" in Header name ex. "CS&T" comes back CS&[Time]? | Excel Discussion (Misc queries) | |||
Range("cell").Select Problem | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |