How do I add row shading to a data table in Excel? How do I have every other row a subtle coloring format?  



1 Answer | Add Yours

vixen999's profile pic

Posted on (Answer #1)

In eXcel, select the cells in the row that you want to highlight and go up to the "Home" tab and use the bucket to select a color.  For a subtle coloring format, you would probably want to use one color such as a a medium purple for every other row and a light lavender for every other row.

We’ve answered 287,795 questions. We can answer yours, too.

Ask a question