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

  • Thread starter Thread starter Guest
  • Start date Start date
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..
 
Unfortunately, this method will not survive sorting, inserting and deleting
rows.

The CF method at Chip's site will.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

how to shade every other 5 rows 7
Need help with Macro's and Shading 7
How to shade groups of rows in excel. 1
Word Dashed line formatting 0
Shading in excel 11
Shading A Line Using Accent, etc. Why Other Changes Also ? 1
Shaded Rows 5
Hide and unhide shaded cells 12

Back
Top