Homework Help

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

animalover4546's profile pic

Posted 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

vixen999's profile pic

Posted (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