Blogger Reflection- Google Sheets Poster Printing

This week I read an old post shared by Meredith Akers about using Google Sheets to make and print posters. You can read this post here. In my Kindergarten classroom I try to use bring colors, posters and pictures to make my classroom feel welcoming and inviting. At the beginning of the school year, I always take pride in putting together my classroom but unfortunately this can be a costly task. I found this post to be beneficial because it showed me an easy way to create posters for my class that I can print at school. This allows me to make posters that are unique to our class content, behavior plans or decor.  The font choices you can choose from on google are awesome!

Here are the steps to make your own poster on Google Sheets:

• Open Google Sheets
• Create and/or insert poster image
• Go to Insert, Drawing, and use Word Art, Text Boxes, Shapes, etc. to create your poster,
• Create your poster in Slides or Drawings and then download as a picture (,jpg or .png) and then insert the picture into your Google Sheets

In your Google Sheet, go to View, Zoom, 50% so you can see a huge portion of your screen.

Ignore the cells – they are just background noise for this project.

Stretch out the image so it takes up as much room as possible

Hold down shift as you click and drag a corner to keep the proportions equal.

Now, set it up to print as a multi-page poster:

• Go to File
• Print
• Make sure your paper size is set to letter (if that’s what you’re using)
• Under “Page Orientation”, choose between Portrait and Landscape based on how you want to piece together your poster
• Choose “Set Custom Page Breaks” in order to drag and drop the page breaks to places that would be easiest to piece together
• One great thing is that when it prints, a little overlap is printed on each piece for easy matching up.
• Move the dotted lines that represent page breaks until you are happy with how it will print.

These posters would be great for anchor charts, class projects creating digital posters, bulletin board displays, class banners or any display at school. Enjoy!