Skip to content
Home » Google » Google Sheets: Add Page Breaks

Google Sheets: Add Page Breaks

Google Sheets Page Breaks

Add a Page Break to Google Sheets

Need to print a Google Sheets spreadsheet? Now you can custom set your page breaks. Here is a spreadsheet for you to try it out on!

Control P

Print! Control P or use the File menu and choose Print.

Control P

Want More Help with This? Become a Premium Member

Set Custom Page Breaks

In the print settings, look for the blue text that says “Set custom page breaks.”
Set custom page breaks

Adjust Default Breaking Points

A preview shows you how Google Sheets thinks your pages should be broken.
Setting the Page Breaks


As you hover your mouse over the default breaks, they seem to JUMP ALIVE! Grab and drag the blue lines to where you desire them to be.
Drag Page Breaks

Confirm the breaking points and you’re all set to print!
Confirm the page breaks

How to Update Student Spreadsheets

You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is…

Google Docs Google Play App Store Install

If you use Google Docs you want to be sure to have the mobile version as well. Use google play app store install

Navigate Google Forms Sections

If you use Google Forms you want to be using SECTIONS in Google Forms and controlling how students navigate the Form.. Navigate Google Forms Sections

BETTER – Print Google Form Quiz

Have more control over how your Google Form™ Quiz prints. Sometimes you need your Google Form on paper and this solution will help you to do it better! Print Google Form Quiz to a Google Doc and custo…

Something Fun for the End of the Year

What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my tem…

2 thoughts on “Google Sheets: Add Page Breaks”

  1. Pingback: Google Sheets: Add Page Breaks – Technology and Electronics

  2. Pingback: Google Sheets: Create Fake Data - Teacher Tech

Leave a Reply

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