Highlight alternate rows or columns of data with colors or patterns to improve the readability of your Excel worksheets.

Here's how: Select the range of cells that you want to format. Go to Home > Format as Table. Pick a table style that has alternate row shading. To change the shading from rows to columns, select the …

Highlight alternate rows or columns of data with colors or patterns to improve the readability of your Excel worksheets.

Make a table to shade or highlight alternate rows. The easiest way to apply shading or highlighting to alternate rows is to make them a table. Tables also include tools to help you analyze your data.

Here's how: Select the range of cells that you want to format. Go to Home > Format as Table. Pick a table style that has alternate row shading. To change the shading from rows to columns, select the …

Learn how to select cells, ranges, entire columns or rows, or the contents of cells, and discover how you can quickly select all data in a worksheet or Excel table.

How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria,—such as the last cell on …

Adding shading to a table can help make certain rows, columns, or cells—or the entire table—stand out in your document. The easiest way to add colored shading to a table is to use the Shading menu.

You can select cells and ranges in a table just like you would select them in a worksheet, but selecting table rows and columns is different from selecting worksheet rows and columns.