Row Shading

G

Guest

I want to know if there is an easier way to shade alternating rows if I have
a long list of data. I want to alternate white/grey throughout the list,
however, when I sort the data or add new data, I do not want to have to redo
the row shading. Is there a way to set that up?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alternate row shading on filtered data 2
How do I alternate shading of rows, Excel 2007, no new tabs. 1
alternate row shading kept with autofilter 3
How do I fix the background shading by position? 2
Conditional Formatting Shading For Visible Rows Only 3
Alternating shading of varying groups of rows 3
Conditional formatting 3
Is there a non-printing shading? 1

Top