If you have ever had to read from a large spreadsheet, especially of just numbers, you know how difficult it can be. The thin lines that separate the rows and columns can be challenging to follow, especially if you have lots of rows/columns, and/or if they are just numbers, so they are harder to read.
One way to make it easier to read is to use alternating row colors, so the human eye can follow each row a little easier. Sometimes called Zebra Striping, this is fairly easy to to do in Microsoft’s Excel. You will simply want to select a Format as Table from the Style section of your Home Tab.
When you click on this button, a pull down of the many different styles will appear. Excel has included a variety of styles for you to pick from, so that you can easily change the way your table looks. This will allow you to style your header in different ways, as well as changing your row colors.
Watch how easy it is to change your data formatting.
Quick Tip: Setting Alternating Row Colors in Microsoft Excel was originally found on Access 2 Learn