Homework Help

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

user profile pic

animalover4546 | Student, Undergraduate | (Level 2) Honors

Posted September 19, 2012 at 9:45 PM via web

dislike 1 like

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

user profile pic

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

Posted September 20, 2012 at 4:49 PM (Answer #1)

dislike 0 like

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.

Join to answer this question

Join a community of thousands of dedicated teachers and students.

Join eNotes