top of page
Writer's pictureDp

How To Color Only Visible Cells In Excel

Updated: May 12, 2018

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

1 comment

Recent Posts

See All

1 Comment


Guest
Sep 18, 2023

thank you. ive been looking for this for months T.T lifesaver


Like
bottom of page