In Microsoft Excel 2007, how do you fill in alternate row colors.?

Question

I've been trying to figure it out for days, it's ridiculous. I want to just have alternating colors for rows.

Answer 1

press the Ctrl button and click on alternate rows.. (click on the leftmost numbers 1, 3, 5... to select the whole row..)
now in font section, there's a fill color option. select the color. and ur alternate rows will get colored..

Answer 2

A quick and easy method is to use the Auto Format feature. Select the area you want to format (if you want to format the entire thing just click in the box beside Column A).

Click on the Home tab. In the Styles group select "Format as table". Select one of the styles you prefer. It will then ask if your table has headers or not, if it has a header select yes, if it doesn't have a header it will create one for you (named Column 1, Column 2, etc).

The one thing it does though that might confuse you is that it adds a filtered list (see the small down arrow beside the header). If you do not want to use the filtered list, select the Data Tab and deselect the Filter button which is found in the Sort and Filter group.

The real cool thing is that if you add a row in after you do this - it automatically corrects the formatting so it still alternates the colours.

To clear all formatting, select the area and under the Home tab, in the Editing group, select clear and then select formats.

Cheers.

Answer 3

How approximately getting rid of the conditional formatting altogether? try this fairly: a million. spotlight the different row for extra or less 10 rows and then fill with easy gray 2. go with the completed section and double-click the format-Painter button 3. go with something of the sheet 4. click the format-Painter button returned to uncheck it. That way you nevertheless the different row gray, yet you may then exchange in this subject if mandatory.

Answer 4

Likely, the same way you do it in previous versions. See Chip Pearson's article:
http://www.cpearson.com/excel/banding.htm