Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.

Excel will automatically apply the zebra stripes pattern to your table, with alternating row colors for easy reading. This formatting will also apply to any new rows added to the table.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

We show you how to autofit in Excel for both columns and rows, using double-click. shortcuts, and the ribbon.

You can switch columns and rows in Microsoft Excel using the Transpose function. It works with a formula we'll show you here or by using paste options.