hidden rows failed stay hidden, when pressing filter

[tiong999]

Hello Dear all,

Somehow i feel annoying about my excell settings, which seems my hidden rows always show up again if i filterize.
The rows i need it stay hidden until i right click show command by ittention.

For example, i hide rows number 7 which contain A letter.
When i filter A letter....hidden rows number 7 show up; i dont want it show up like this.

Thanks for your assistance.

 

[NARAYANK991]

Hi ,

Apply Haseeb Avarakkan's suggestion from this link :

https://answers.microsoft.com/en-us...den-rows/5be21518-409d-4f3d-9db8-cce0559a5618

Narayan

 

[tiong999]

Hi ,
Narayan

Hello,

Unfortunately it explain the opposite way (to showed hidden row).

Sorry, but i can't absorb that explaination in opposite way which my difficulties to stay hidden.

Regards
Tiong999

 

[NARAYANK991]

Hi ,

1. Let us start with the following conditions :

• Remove all filters from the AutoFilter.

• Select the entire worksheet and set a row height of 20.

2. Select row #7 , and set a row height of 0.25 ; effectively the row is hidden.

3. Set a filter for A in column B. Only rows 3 and 4 are displayed.
Row #7 remains hidden.

4. Select All from the AutoFilter ; all the rows except row #7 are displayed.

If this is not what you wanted , please ignore this post.

Narayan

 

[tiong999]

Narayan

Hi...Sorry late reply u, since i was going out.

Actually this is not what i seek, but this does help.

I appreciated it dude.

Regards,
Tiong999

 

[vletm]

tiong999
1) You start from this - okay?


2) FILTER those rows which You want to be 'hidden' - okay?
(ex with text HIDE HERE)


3) Select next column which You want to FILTER - okay?


4) Filter if as You need - Okay?
(Those the 1st filtered row are 'hidden' as long time as You need - Okay?)

 

[tiong999]

Hello bro,

Unfortunately that is not why i was asking, since i knew it should be that way in normal condition. But, the problem is my excel setting was change as i change my harddrive on my pc, suddenly i can't filter it that way and i got this problem.

Anyway, i appreciated for ur kindness.

PS: Maybe it something around Excel Options >> Advanced

Regards,
Tiong999

 

[vletm]

tiong999
Yes ... You wanted first hide and after that filter ...
if You get that work 'Your way' please let me know too.
So far:
If You first hide some rows manually and
after that You'll make filter then filter will do what it should do; filter!
- hidden rows will stay hidden if filter "lets those be hidden".
If You first filter something and
after that You'll hide something then hide will do what it should do; hide!
- You can hide only visible rows.
If You first filter something and
after that You'll filter something else (as my sample) 2nd filter will do what it should do; filter again (including 1st filtering)!