In this short tutorial I will show you how to alternate Row Colors in Microsoft Excel.

If you want to have automatically applied shading/color to every other row or column in a worksheet, I have the sollution.

A way to quickly add shading or banding to alternate rows is by applying a predefined Excel table style.

This method has the added benefits of tables, for example, table headers will be automatically displayed in the filter drop-down lists.

By default, banding is applied to the rows in a table to make the data easier to read. The automatic banding continues if you add or delete rows in the table.

If you find this useful, please drop a on the video and subscribe

Timestamp:
00:00 Intro
00:17 What we want to do?
00:40 Solution
01:29 This is how you do it!

RECOMMENDED VIDEOS/PLAYLISTS
Financial functions: https://www.youtube.com/watch?v=FrD2B_nEnSc&list=PLQHFVtY7qRavbgxjqGGE6t3TSlpToYztl&ab_channel=ExcelCogTutorials
Common errors: https://www.youtube.com/watch?v=cDBSxgH_WLU&list=PLQHFVtY7qRatNX2w9ov3B2On7FdJiniXG&ab_channel=ExcelCogTutorials
How to tutorials: https://www.youtube.com/watch?v=LZkMf8tMnDw&list=PLQHFVtY7qRaufg0mmtiP3NWvHJCo0WT07&ab_channel=ExcelCogTutorials
Regular functions explained: https://www.youtube.com/playlist?list=PLQHFVtY7qRasFz48oVe-4IbO-jQfY1_9v

Feeling generous? I like coffee.
https://www.buymeacoffee.com/cogwheel

Please take the opportunity to connect and share this video with your friends and family if you find it useful.