how can I shade alternate rows in Excel 2007?

L

lingo123

I know two ways to do a simple shade-every-other-row format in Excel 2003
(either use the preset "List 1" under AutoFormat, or select each row
individually that you want to shade). Does it work the same way in Excel
2007? If not, how do you do it? Thanks!
 
J

Jim Rech

In addition to the techniques the others have offered there is the new Excel
2007 "Format as Table" command on the Home tab. If you pick one of the
banded styles Excel will automatically handle keeping the table properly
banded when to add data or insert and delete rows.
 

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

shading rows in excel 10
Use VBA to shade every 3 rows (banding) 6
Excel 2007 Range Selection 2
how do you shade every othe row in excel 2007 2
shade rows 2
How do I shade alternate rows in Excel 2002? 2
How can I shade each alternate Excel row without selecting each? 4
how do I shade alternating rows in spreadsheet 7

Top