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

vixen999 | High School Teacher | (Level 2) Adjunct Educator

Posted on

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 320,050 questions. We can answer yours, too.

Ask a question