In excel, how do I shade every other line in the rows?

S

SeaparkJohn

IN an empty spreadhseet, hightlight Row 2 and change it to the colour of your
choice. Now highlight row 1 and row 2, press on the formatting button (the
paintbrush) and drag from row 3 down as far as you like. This will colour
every second row in the colour you selected.

Hope this helps..
 
G

Gord Dibben

Unfortunately, this method will not survive sorting, inserting and deleting
rows.

The CF method at Chip's site will.

Gord Dibben Excel MVP
 

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

Indenting every other paragraph in Word at the same time? 0
How to shade groups of rows in excel. 1
Autonumber field in Excel that behaves the same as Access 0
how to shade every other 5 rows 7
How to make the shading look uniform around a double spaced line in MS Word? 0
Document Merge Formatting Issue 0
Shade a section under line graph in excel 0
Shaded cells shift to the right when printing 1

Top