Looking at large amounts of data can be quite straining on the eyes. Thankfully Excel has a useful function to make it easier – alternate row styling. Simply put: Zebra striping. Shading rows in alternate colours is a great way to make large amounts of data easier to work with.
Don’t worry, you won’t have to colour your rows manually. You can apply it all in just a few clicks. Here’s how to add colour to your file.
First, select your entire table, then click on Format as Table in the Home tab of your Excel menu.

You’ll see a series of options and colour choices. Pick whichever one you prefer. The presets include options featuring different shades of colour, outlines and heading tones. When you’ve found an option you like, click on it. The styling will be applied to your table immediately.

Tip: If you want to change the colouring, simply repeat the steps and click on a different pre-set.
Did this help? Let us know!