Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2000: Lines hidden with filter
With a tabelle of daten.
After I have filtered my lines with a criterium, I decide to hide those lines. But when I go back on to my fiter to release the criterium, I would like the filter to remember that I have hidden the previous lines, so that they don t appear again. How can I do this? Thank you. Simon |
#2
|
|||
|
|||
do you mean that you want to filter the lines again?
"Simon" wrote in message ... With a tabelle of daten. After I have filtered my lines with a criterium, I decide to hide those lines. But when I go back on to my fiter to release the criterium, I would like the filter to remember that I have hidden the previous lines, so that they don t appear again. How can I do this? Thank you. Simon |
#3
|
|||
|
|||
Not exactly.
As I said, after filtrying the lines with a criterium, I have hidden the lines selected by the filter. What I would like is that those lines stay hidden when I want to see all the other lines. Or when I take of the filter. By the way would you be able to answer the question I have asked just after? Thank you. "jiwolf" schrieb: do you mean that you want to filter the lines again? "Simon" wrote in message ... With a tabelle of daten. After I have filtered my lines with a criterium, I decide to hide those lines. But when I go back on to my fiter to release the criterium, I would like the filter to remember that I have hidden the previous lines, so that they don t appear again. How can I do this? Thank you. Simon |
#4
|
|||
|
|||
I think I'd use a helper column.
Instead of hiding those rows manually, put some indicator in that helper column. Then you could just filter by that column to show blanks (hide the rows with the indicator). Simon wrote: Not exactly. As I said, after filtrying the lines with a criterium, I have hidden the lines selected by the filter. What I would like is that those lines stay hidden when I want to see all the other lines. Or when I take of the filter. By the way would you be able to answer the question I have asked just after? Thank you. "jiwolf" schrieb: do you mean that you want to filter the lines again? "Simon" wrote in message ... With a tabelle of daten. After I have filtered my lines with a criterium, I decide to hide those lines. But when I go back on to my fiter to release the criterium, I would like the filter to remember that I have hidden the previous lines, so that they don t appear again. How can I do this? Thank you. Simon -- Dave Peterson |
#5
|
|||
|
|||
thank you very much and would you be also able to answer the next question I
have posted? "Dave Peterson" schrieb: I think I'd use a helper column. Instead of hiding those rows manually, put some indicator in that helper column. Then you could just filter by that column to show blanks (hide the rows with the indicator). Simon wrote: Not exactly. As I said, after filtrying the lines with a criterium, I have hidden the lines selected by the filter. What I would like is that those lines stay hidden when I want to see all the other lines. Or when I take of the filter. By the way would you be able to answer the question I have asked just after? Thank you. "jiwolf" schrieb: do you mean that you want to filter the lines again? "Simon" wrote in message ... With a tabelle of daten. After I have filtered my lines with a criterium, I decide to hide those lines. But when I go back on to my fiter to release the criterium, I would like the filter to remember that I have hidden the previous lines, so that they don t appear again. How can I do this? Thank you. Simon -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) | |||
Excel 2003 V's Excel 2000? | Excel Worksheet Functions | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |