How to make dot grid paper in multiple sizes using Google Sheets Featured Image | SaturdayGift

Disclosure: This post may contain affiliate links, which means I may receive a commission if you click a link and purchase something that I have recommended. Please check out our disclosure policy for more details.

Gift Forward by Sharing This Post! <3

Want to create your own printable dotted paper for your bullet journal? Here you can find step-by-step instructions on how to make dot grid paper using Google sheets.

Dot grid paper is perfect for bullet journaling and if you’re worried about using your new bullet journal notebook you can first practice pretty handwriting and making cute drawings using the printable dot grid paper.

And here you can find step-by-step instructions on how to make dotted paper using Google Sheets. 

How to make dot grid paper in multiple sizes using Google Sheets Pinterest Image | SaturdayGift

Materials I use and recommend

If you need to resize the printable: 

What is dot grid paper

Dot grid paper or dot paper is a sheet of paper that instead of being blank or having lines or grids on it, it has dots on it. The distance between the dots is usually 0.5 cm and depending on the paper size you use there are around 25×40 to 35×50 dots on each paper.

And you can easily make your own dot grid paper using Google Sheets. 

Note: You can definitely make dotted paper using Excel/Number or Word/Pages, but because not everyone have those programs I wanted to make this tutorial using a free program that everyone can have access to. 

In this post I’m going to walk you through on how to create letter-sized 0.5cm dot grid paper.

But you can use this tutorial to make different sized printable dotted paper as well. 

After the step-by-step tutorial, I’ll give you guidelines how to resize your paper and make half letter, A4 and A5 dot grid paper as well. 

So here we go. 

Don’t want to make your own dotted paper? Use mine! 

You can download free printable dot grid paper I’ve made from this post: Free printable dot grid paper for bullet journal (multiple sizes)

Don’t want to print out the dot paper?

There are some good dot grid loose leaf options in Amazon. 

Step-by-step instructions on how to make dot grid paper using Google Sheets (DIY)

1. Start by opening Google Sheets

2. Resize your paper/Google sheet (steps 1-4)

  • Click “print” (1.)
Step 1: Resize page | How to create dot grid paper using Google Docs
  • Change settings (2.):
    • Paper size: Letter (8.5″ x 11″)
    • Page orientation: Portrait
    • Scale: Normal (100%)
    • Margins: Custom Margins
Step 2: How to make dot grid paper in Google Sheets
  • Change margins (3.):
    • Change all margins to 0.25″ (Top, Bottom, Left and Right)
  • After you’ve changed the settings and the margins click “cancel” (4.)
    • Don’t worry! You won’t lose your settings you just made. You’ll just return to the sheet.
Step 3: How to make dot grid paper in Google Sheets

In the next steps I’ll show you how to make letter sized dot paper.

US letter: Columns A-AL, Rows 1-53. 

If you want to make different size paper use these:

Half letter: Columns A-X, Rows 1-40 (you can skip steps 9-11)

A4: Columns A-AK, Rows 1-56

A5: Columns A-Y, Rows 1-39 (you can skip steps 9-11)

3. Resize the columns + add extra columns (steps 5-11)

  • Resize the columns to create the right size grid for the dots:
    • Choose all columns from A to Z by clicking on ‘A’ and dragging your mouse over A-Z (5.)
    • When all columns from A to Z are active, right-click your mouse (6.) and a menu appears
    • Choose ‘Resize columns A-Z’  from the menu (7.)
Step 4: How to make dot grid paper in Google Sheets
Step 5: How to make dot grid paper in Google Sheets
  • Change the pixels to 19. (8.)
    • We want to create a dot grid paper where the distance between the dots is 0.5 cm.
    • 19 pixels = 0.5 cm. 
Step 6: How to make dot grid paper in Google Sheets
  • Add more columns to create enough columns and dots for a letter sized paper. (9.-10.)
    • Google sheets only gives you columns from A-Z so we need to add more columns. If you use Excel or Pages you should be able to skip this step.
    • Add more columns by choosing ‘A-M’ by clicking on ‘A’ and dragging your mouse all the way to ‘M’. 
    • Copy columns A-M by clicking command+C on Mac or CTRL+C on Windows. 
    • Click on Z and paste the copied columns by clicking Command+V on Mac or CTRL+C on Windows. (10.)
    • You should end up with columns from A to AL. (11.) That’s enough columns to create a letter sized paper
Step 7: How to make dot grid paper in Google Sheets
Step 8: How to make dot grid paper in Google Sheets

4. Resize the rows (steps 12-15)

  • Resize the rows to create the right size grid for the dots:
    • Choose the rows from 1 to 53 by clicking on ‘1’ and dragging your mouse down all the way to ’53’
    • When all rows from 1 to 53 are active, right-click your mouse (13.) and a menu appears
    • Choose ‘Resize rows 1-53’  from the menu (14.)
Step 9: How to make dot grid paper in Google Sheets
Step 10: How to make dot grid paper in Google Sheets
  • Change the pixels to 19. (15.)
    • We want to create a dot grid paper where the distance between the dots is 0.5 cm.
    • 19 pixels = 0.5 cm. 
    • After you’ve done this you’ll end up with  a google sheet that has the right sized columns and rows on it and now we can add the dots on the grid. 
Step 11: How to make dot grid paper in Google Sheets

5. Add dots on the cells (steps 16-18)

  • Write a dot in the cell ‘A1’. (16.)
  • Copy the dot to all cells on the first row by clicking in the bottom corner of the cell ‘A1’ and dragging your mouse all the way to ‘AL1’. (17.)
  • The dots should appear on all cells on the first row.
Step 12: How to make dot grid paper in Google Sheets
  • Then click in the bottom corner of ‘AL1’ and drag your mouse all the way down to ‘AL53’. (18.)
  • The dots should appear on all the cells.
Step 13: How to make dot grid paper in Google Sheets

6. Center and change the color of the dots and  (steps 19-22)

  • Center the dots by activating all the cells by clicking in the corner – the activated cells appear blue/gray on the sheet. (19.)
  • Center the cells by clicking ‘Horizontal align’ and choose ‘Center’ – the middle one. (20.)
Step 14: How to make dot grid paper in Google Sheets
  • Change the color of the dots by activating all the cells by clicking in the corner – if they’re not already activated. (21.)
  • Change the color by clicking ‘Text color’ and choose ‘Gray’ or another color of your choice. (22.)
  • The color ‘Gray’ creates light enough dots that they’ll still help you write and draw but don’t show too much on the paper
Step 15: How to make dot grid paper in Google Sheets

7. Print the dot grid paper you’ve created (steps 23-25)

  • Click ‘Print’ (23.)
Step 16: How to make dot grid paper in Google Sheets
  • Double-check settings (24.):
    • Paper size: Letter (8.5″ x 11″)
    • Page orientation: Portrait
    • Scale: Normal (100%)
    • Margins: Custom Margins (all 0.25″)
    • Formatting: De-select ‘Show gridlines’ & ‘Show notes’ 
Step 17: How to make dot grid paper in Google Sheets
  • When you’ve double-checked the settings & margins, click next (25.)
  • By clicking next Google Sheets creates a PDF document of your dot grid paper
  • Open PDF from your downloads
  • Print out your dotted paper and add it to your notebook, binder, planner or bullet journal or use it as-is. 
Step 18: How to make dot grid paper in Google Sheets

8. Want to make different size dot grid paper

  • Steps 1-4 are the same
  • When you resize the columns (steps 5-11) and rows (steps 12-15) choose these dimensions instead:
  • Half letter:
    • Columns from A to X
    • Rows from 1 to 40
  • A4:
    • Columns from A to AK
    • Rows from 1 to 56
  • A5:
    • Columns from A to Y
    • Rows from 1 to 39
  • Steps 16-25 are the same as in the step-by-step tutorial .

I hope you were able to create the dot grid paper using Google Sheets and let me know in the comments if you did!


Want to remember this?

Pin this post – how to make printable dot grid paper in multiple sizes – to your favorite Pinterest board.

How to make dot grid paper in multiple sizes using Google Sheets Pinterest Image | SaturdayGift

Similar Posts

4 Comments

  1. Thank you so, so, so much for doing this tutorial! I was able to expand it to do 2 half size for printing double sided on letter paper. I wasted so much time searching the web for something already constructed, and here were instructions on how to get exactly what I needed. Thank you again!

    1. Yay! Thank you so much for your comment, Laura! I’m so happy to hear you found this tutorial helpful and that you were able to create exactly what you needed! Love it!

      Cristina
      Creator of SaturdayGift

  2. Thank you for the tutorial. Takes a little work, but its nice to learn how to manipulates google sheets. It becomes intuitive after a little practice.

    I found the dots on every other line to be most useful without being to intrusive.

    1. Hi Don.
      I’m glad to hear you found the tutorial helpful and that you were able to create the dot paper for your needs by having dots on every other line. I have to try that too!

      And if you ever need to print out dot paper fast, I have another post where you can download ready-made printable dot paper in multiple sizes instantly without signing up: Printable Dot Grid Paper for Bullet Journaling – multiple sizes

      Sincerely,
      Cristina
      Creator of SaturdayGift.com

Leave a Reply

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

I accept the Privacy Policy