How to Show the Print Area in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on August 24, 2023

This tutorial demonstrates how to show the print area in Excel and Google Sheets.

show print area intro

Page Break Preview

▸ In the Ribbon, go to View > Worksheet Views > Page Break Preview.
show print area ribbon

OR
▸ In the bottom-right corner of your screen, change your view to Page Break Preview.
change print area page break preview

You can see the set print area on your screen enclosed in a blue border.

Show Print Area in Google Sheets

Google Sheets does not have the ability to set a specific print area. However, you can choose to view your selected range in Print Preview mode of Google Sheets.

  1. Select the cells you wish to print and then, in the Toolbar, click the Print button.

change print area gs print button

  1. In the Print drop down on the right side of the screen, choose Selected Cells to only show a preview of the cells you have selected.

change print area gs

Tip: See how to change or clear print areas, too.

AI Formula Generator

Try for Free

See all How-To Articles