formatting alternating rows

J

Joe

Autoformatting may be the easiest way. Select Format,
then Autoformat. There are a couple that have alternating
gray/white rows.
 
J

JMay

I prefer using Conditional Formatting...
Example, Click on Row-Header 5 select CF, then Formula IS and insert
=MOD(ROW(5:5),2)=1; then Pattern Gray, OK, OK...
Use Format Painter to duplicate downward as far as you want..
HTH
 

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

Top