[EXCEL] Shade Alternate Rows in Excel 2007

One way to quickly add shading to alternate rows in Excel 2007 is by applying a predefined table style.

By default, shading  is applied to alternate rows in an Excel 2007 table to make the data easier to read.

The alternate row shading will remain accurate even if you add or delete rows.

 

  • Select the range of cells you want to format
  • On the Home tab, in the Styles group, click Format as Table
  • Under Light, Medium, or Dark, click the table style you want to use
  • In the Format as Table dialog box, click OK.
    Notice that the Banded Rows check box is selected by default in the Table Style Options group.
    To apply shading to alternate columns instead of alternate rows, clear this check box and select Banded Columns
  • If you want to convert the Excel table back to a regular range of cells, click anywhere in the table to display the tools necessary for converting the table back to a range of data
  • On the Design tab, in the Tools group, click Convert to Range
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s