How to Make a Crossword Puzzle on Google Sheets

PDF download Download Article
PDF download Download Article

Solving crossword puzzles is a great mental exercise, but learning to make your own will take your acrostic skills to the next level! Whether you want a fun way to practice your vocab words or you want to try your hand at making a newspaper-worthy cipher, you can use Google Sheets to easily create a puzzle for any skill level. From there, it's just a matter of coming up with your own crossword clues!

Part 1
Part 1 of 2:

Formatting Your Puzzle

PDF download Download Article
  1. Create your list of crossword answers. If you're just making a simple puzzle, come up with about 10-15 answers that all tie back to a central theme. For instance, if you're making a puzzle for school, you might choose words that tie back to a lesson you're studying or a book you read. If you're making the puzzle for fun, the theme could be anything, like a list of movies you like or your favorite foods. [1]
    • It's usually easiest to start by creating your answer list first. That way, you'll have a good idea of what length and width your crossword grid needs to be.
    • If you're making a newspaper-style puzzle, start by listing several longer answers that fit your theme. You can fill in the rest of the words later on.
    • Since newspaper crosswords have blocks of intersecting words, they're more complicated to create. It's okay if you don't know every single word you'll use in advance.
  2. Using a spreadsheet is the easiest way to nail down the grid shape for your crossword. Just go to https://sheets.google.com or open your Google Sheets app, then click the "+" icon to start a new spreadsheet.
    Advertisement
  3. To do that, click on the very top left box on the spreadsheet, or the blank box above row 1 and left of column A. You should see the whole spreadsheet turn blue—that means all of the columns and rows have been selected. [2]
    • When the whole sheet is highlighted, if you resize one row or column, the change will apply to all of the rows or columns.
  4. Click and drag the line between columns A and B until column A is the width you want your crossword squares to be. Then, resize the height of row 1 so the cells are square. Make sure the square is big enough to hold one letter. [3]
    • Each time you release your mouse, all of the cells in the sheet should automatically resize, so you should end up with a whole sheet of neat squares.
    • You won't necessarily use the whole spreadsheet for your crossword puzzle, but this is the easiest way to create even squares for your grid.
  5. Pick a cell that's roughly in the center of where you expect your crossword to go. Then, type a name for your puzzle, like "Anna's Crossword Puzzle" or "Crossword 11-19-2021." [4]
    • If you know you're going to build your crossword around a certain theme, you might use that as the name, like "National Parks Crossword" or "All About Space."
    • You might need to adjust the font size so your title is easier to see.
    • If the title looks off-center later, you can always shift it to a different cell.
  6. The dimensions of your puzzle will depend on how many words you're using and how long the words are. Your grid needs to be at least big enough to contain your longest word or phrase, but it may need to be larger than that depending on your layout. Once you decide on the size, click the cell that you want to be the top left square in your puzzle, then click and drag your cursor so the whole grid is selected. [5]
    • If you're just doing a simple crossword, consider sketching it out on scrap paper to get an idea of the dimensions you'll need to use. [6]
    • Conventionally, most crossword puzzles are square, but if you want to create a rectangular grid, you can.
    • If you're creating a newspaper-style crossword, it should be 15 cells across and 15 cells high for a daily puzzle or 21x21 for a Sunday puzzle. [7]
  7. Click the 'Borders' button in your toolbar, which looks like a square with a cross in it. A dropdown menu will appear. From there, click the option "All borders"—the icon looks exactly the same as the 'Borders' button. [8]
    • This will create a border around each cell in the highlighted section.
  8. These are the columns where you'll type your clues. Skip 5 or 6 columns on the right side of your grid, then type "Across" into a cell. Skip another 1-2 columns, then type "Down" into a cell on the same row. [9]
    • Since these columns aren't included in your grid, you can resize them to be wider so the clues will be easier to read. Just don't adjust the height of the rows—that will mess up the formatting of your crossword grid.
    9. Advertisement
Part 2
Part 2 of 2:

Building the Puzzle

PDF download Download Article
  1. Each answer should share a letter with at least one other word. Place some of the words vertically and some horizontally so they intersect across the letters they have in common. To make sure they'll fit, it's a good idea to start by placing the longest words first. Then, fit your smaller words in around that. [10]
    • It can help to zoom out on the document while you're doing this.
    • Adjust the formatting in your document so the letters are center-aligned. This will help the crossword look neater. [11]
    • In a newspaper-style puzzle, every letter needs to be in both an across word and a down word, creating blocks of squares. For instance, if your 1 Across is the word "MAST," you'll have a down word starting from each of those 4 letters. [12]
  2. Once you've placed all of your words, click on an empty square, then click the "Fill" icon on your toolbar—it looks like a tipped-over paint can. Choose black to fill the square. Then, repeat that for all of the remaining empty squares on the puzzle. [13]
    • On a PC, make quick work of this by hitting CTRL+C to highlight the filled square. Use the arrow keys to move the cursor to another blank square and hit CTRL+V to fill it.
  3. Work through the grid from left to right and top to bottom. When you get to the first square that contains a letter, type the number "1." into that cell. That will be your "1 Across" answer. Continue to the next cell that starts a word and number it with 2, and so on. Then, do the same thing for your "Down" clues by working from top to bottom and left to right. [14]
    • If two words both start on the same cell, they'll share a number. For example, if "ASTRONAUT" and "AEROSPACE" intersect on the first A, they might be numbered "1 Across" and "1 Down."
    • If a word starts in the middle of another word, it should get a new number. For instance, if the word "ASTRONAUT" starts on the second letter in "NASA," then "NASA" might be "1 Across" and "ASTRONAUT" might be "2 Down."
  4. Now that your puzzle is all filled out, it's time to create the hints that your audience will use to solve the crossword. The best clues are short—only a few words long. It's up to you how easy or tough the clues would be, but each clue should be solvable. [15]
    • For instance, for the answer "PURPLE," you wouldn't use a clue like "My favorite color." Instead, try a clue like, "The color of royalty," "Eggplant hue," or "Some blueberries, oddly."
    • If your answer is "STOP," your clue might be "Halt" or "Octagonal direction."
    • For the word "GRASS," you might use a clue like, "Ground covering," "Turf," or "Snake's place."
    • Try using a thesaurus if you get stuck coming up with a clue.
    • More advanced crosswords frequently use clues containing puns, anagrams, and words that sound similar, as well. [16]
  5. As you create each clue, put it in the appropriate clue column. All of the clues for horizontal words should go in the "Across" column, and all of the clues for vertical words should go in the "Down" column. Make sure each clue shares the same number as its corresponding answer. Type one clue in each row in the appropriate column, going in number order. You may need to resize these columns a little to make all of the clues fit. [17]
    • You may need to resize the Across and Down columns to make sure all of the clues fit.
  6. Click on "File," then "Make a copy." A box will pop up prompting you to name this copy and choose where to save it. Once the copy loads, go through the grid and erase all of the letters from the whole puzzle. Now you have a copy you can share with other people! [18]
    • You may need to retype the numbers back into the puzzle after you erase the squares.
    • Be sure you keep the copy with the words—that's your answer key!
    7. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Play Charades: Rules, Gestures, & More
      How to
      Set Up and Play Bananagrams
      Beat Wordle Every Time: The Best 5-Letter Words & Tricks
      How to
      Solve the Water Jug Riddle from Die Hard 3
      How to
      Make Crossword Puzzles
      The 30 Cows and 28 Chickens Riddle Explained
      How to
      Play Boggle
      How to
      Play the Elephant Game
      How to
      Unscramble Words
      How to
      Solve a Cryptogram
      How to
      Make up a Riddle
      6 Helpful Hints for Solving Riddles (with Examples to Answer)
      12 Strategies to Win Words with Friends Every Time
      How to
      Solve Anagrams Effectively
      Advertisement

      References

      1. ↑ https://youtu.be/aAqQnXHd7qk?t=99
      2. ↑ https://youtu.be/rRR9OW7wsIU?t=8
      3. ↑ https://youtu.be/rRR9OW7wsIU?t=8
      4. ↑ https://applieddigitalskills.withgoogle.com/c/middle-and-high-school/en/create-a-crossword-puzzle/introduction-to-create-a-crossword-puzzle/set-up-your-crossword-puzzle.html
      5. ↑ https://edu.gcfglobal.org/en/googlespreadsheets/formatting-cells/1/
      6. ↑ https://stmcomputers.edublogs.org/files/2010/09/ExcelCrosswordPuzzle.pdf
      7. ↑ https://www.nytimes.com/2018/05/11/crosswords/how-to-make-crossword-puzzle-grid.html
      8. ↑ https://edu.gcfglobal.org/en/googlespreadsheets/formatting-cells/1/
      9. ↑ https://applieddigitalskills.withgoogle.com/c/middle-and-high-school/en/create-a-crossword-puzzle/introduction-to-create-a-crossword-puzzle/add-a-new-sheet-for-clues.html
      1. ↑ https://youtu.be/RJf9EAld8LU?t=197
      2. ↑ https://youtu.be/RJf9EAld8LU?t=324
      3. ↑ https://www.nytimes.com/2018/05/11/crosswords/how-to-make-crossword-puzzle-grid.html
      4. ↑ https://applieddigitalskills.withgoogle.com/c/middle-and-high-school/en/create-a-crossword-puzzle/introduction-to-create-a-crossword-puzzle/build-your-answer-key.html
      5. ↑ https://www.crosswordunclued.com/2009/10/numbering-clue-slots-in-grid.html
      6. ↑ https://www.nytimes.com/2018/05/11/crosswords/how-to-make-crossword-puzzle-grid.html
      7. ↑ http://www.teazel.com/articles/crossword-clue-types/
      8. ↑ https://applieddigitalskills.withgoogle.com/c/middle-and-high-school/en/create-a-crossword-puzzle/introduction-to-create-a-crossword-puzzle/add-a-new-sheet-for-clues.html
      9. ↑ https://youtu.be/RJf9EAld8LU?t=467

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 29,118 times.

      Did this article help you?

      Advertisement