We do face this problem when we want to color only the visible cells, we generally select all the cells and color them.Later, when we remove the filters, we observe that the hidden cells have also been colored. But, instead we can color only the visible cells using this simple procedure.
Lets see an example here:
I have an excel sheet with the data as shown
and I have hidden the rows 6,7,8
and if I select these cells by normal selection and color it in green color, all the hidden cells will also be colored.
But instead I will select only the visible cells by
1. Selecting all the cells normally and then
2. Pressing "Alt+;"Â on my keyboard which enables to select only the visible cells.
3. And then color the cells by green color. I get the desired result now as shown when I unhide the cells
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.
You can write us at dptutorials15@gmail.com
thank you. ive been looking for this for months T.T lifesaver