Skip to content

Chessboard Pattern in Google Sheets

Whether it’s for fun or another purpose, this article will teach you how to create a chessboard pattern in Google Sheets.

Just follow the steps below.

Step 1 – Adjust the Column Width to 50 px

The first thing you need to do is adjust the column width of columns A through I to 50 pixels.

To do this, select columns A through I, right-click, and select Resize columns A – I.

Next, set the width to 50, and click on Ok.

Step 2 – Adjust the Row Height to 50 px

For step 2, adjust the row height of rows 1 through 9 to 50 pixels.

To do this, select rows 1 through 9, right-click, and select Resize rows 1 – 9.

Then set the height to 50, and click on Ok.

Step 3 – Add a Fill Color to B3 & C2

For this step, select cells B3 and C2 by holding the CTRL key, then apply a dark grey (almost black) fill color.

Step 4 – Use the Fill Handle to Complete the Pattern

To complete the checkered pattern of fill colors, select the range B2:C3.

With the cells selected, use the fill handle to drag the formatting to I3.

Next, use the fill handle to drag the formatting down to I9.

Step 5 – Add an Outside Border

To complete the chessboard pattern, select B2:I9, and add a black border around the outside of this range.

Step 6 – Hide the Gridlines

To make the chessboard pop and stand out on the screen, go to View Show Uncheck Gridlines.

You now have a nice-looking chessboard pattern in Google Sheets.

See It In Action

Check out the video below to see the whole thing from start to finish!

This Post Has One Comment

  1. This is really fun! This would be great to use in Google Sheets for an online version of chess to play with friends!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top