How to Create an Animated Christmas Tree in Excel 🎄

Wishing you a Merry Christmas—the Excel way.

Andrew Moss
7 min readDec 25, 2021

--

CChristmas Day is here, so what better way to celebrate the big day than creating something Chrimbo-themed (in Excel, of course). I am going to show you how to create a pixel art Christmas tree with flashing lights that switch on at the click of a button.

This won’t be the most graphically advanced piece of artwork you’ll make, but it’s a good bit of fun. For you newbies, it’s also a useful introduction to understanding how certain functions can be used, as well as conditional formatting and VBA.

After you’ve finished, you might want to send it to that spreadsheet nut in the office, or friends and family.

I’ve included a finished copy of the workbook at the end of this article, but I will run through the steps from the beginning.

Let’s dive straight into it.

1.

Open a new Excel workbook.

2.

To set the size and shape of the tree, hold down Ctrl whilst selecting cells to form a pyramid. Start from cell P15 and ensure each of the 12 layers is two rows deep. Finish at row 38.

--

--