K
KG
In excel, how do I shade every other line in the rows?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
T
Trevor Shuttleworth
Look at Chip Pearson's site; in particular:
http://www.cpearson.com/excel/banding.htm
Regards
Trevor
http://www.cpearson.com/excel/banding.htm
Regards
Trevor
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..
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
rows.
The CF method at Chip's site will.
Gord Dibben Excel MVP