Google Sheets: Add Page Breaks

Printing Google Sheets spreadsheets, set the page breaks.
Google Sheets 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

Drag

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

Leave a Comment

© 2026 All Rights Reserved.

Get effective EdTech strategies from Alice Keeler to build a more student centered classroom. Includes unique resources and templates.

Recent Teacher Tech Blog Posts

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday April 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for teaching with AI

Imagine having a team of teaching assistants who already know your syllabus and exactly how you like to give feedback. Join Google Certified Innovator Alice Keeler to learn how to use Google Gems to build a powerful collection of custom AI tools. We will explore how to engineer specific instructions so you can create a Grading Assistant or a Classroom Policy Manager that works for you. You will also learn how to leverage Gems shared by other educators to instantly expand your toolkit. This session is about super-powering your teaching by automating the routine tasks so you can focus on the students.

Exit this pop up by pressing escape or clicking anywhere off the pop up.