How to Insert Page Break in Google Sheets

Last Modified: January 13, 2024 - 2 min read

Julian Alvarado

TL;DR: Easily insert page breaks in Google Sheets via ‘File’ > ‘Print.’ Use ‘Set custom page breaks’ in print settings to manually adjust page divisions for optimal printing layout. Regular previews ensure accurate and effective page organization.

When working with Google Sheets, you may need to insert page breaks for printing purposes. Page breaks help to organize your data into manageable sections on separate pages. This post explains how to insert page breaks in Google Sheets effectively.

Step 1: Open Your Google Sheet

Begin by opening the Google Sheets file where you want to add page breaks.

Step 2: Accessing Print Settings

Click on ‘File’ in the menu bar, then select ‘Print’ (or use the shortcut Ctrl + P on Windows, Cmd + P on Mac). This opens the print settings preview.

Step 3: Setting Up Page Breaks

In the print settings preview, click on ‘Set custom page breaks.’ This allows you to manually adjust where pages begin and end.

Step 4: Inserting Page Breaks

Click and drag the blue lines to set where you want the pages to break. You can create horizontal and vertical breaks to organize your data across different pages.

Step 5: Adjusting and Removing Page Breaks

To adjust a page break, simply click and drag the blue line to a new position. To remove a page break, drag the blue line back to the edge of the preview pane.

Step 6: Saving Your Settings

Once you’ve set your page breaks, click ‘Confirm Breaks’ to save your changes. You can then proceed with printing or close the print preview.

Tips for Effective Page Breaks:

  1. Preview Regularly: Use the print preview feature to check how your data will appear on each page. This helps in making accurate page breaks.
  2. Consider Data Grouping: Try to keep related data together when setting page breaks to avoid splitting important information across pages.
  3. Adjust Column Widths and Row Heights: Before inserting page breaks, adjust your columns and rows to ensure data fits well on each page.

Set Spreadsheet Data on Refresh

Try the Spreadsheet Automation Tool Over 300,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 300,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
Google icon
300,000+ users on Google Marketplace
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies