Delete Unwanted or Blank Pages in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on May 27, 2023

This tutorial demonstrates how to delete unwanted pages and print only the first page in Excel and Google Sheets.

print preview excel 1

When you try to print a large worksheet, Excel splits it into multiple pages to fit all of the data for printing. By default, all blank pages are skipped and only those with data are printed. However, sometimes you want to print certain pages or just the first page.

Print Only the First Page

Say you have the following data range in the worksheet.

initial data print excel 1

If you try to print this document, Excel splits it into two pages, since all data can’t fit into one page. To see how the worksheet is split for printing, go to the View tab in the Ribbon and click Page Layout.

excel page layout view 1

Excel splits the worksheet into pages for printing. As you can see in the picture below, the page break is inserted between Rows 49 and 50.

page layout view excel 1

In this case, the records are divided into two pages, as there are too many rows for one page. Now if you want to print only the first page, (1) select all cells on the first page. Then, in the Ribbon, (2) go to the Page Layout tab, (3) click Print Area, and (4) choose Set Print Area.

set print area 1

Now only the first page is set to print. You can go to Print Preview and see if it’s done correctly. Go to Print in the Home tab.

print excel file 1

In Print Preview, you can see that only the first page is set for printing.

print preview excel 1

Like this, you could have set any other page, or group of pages, for printing and removed all unwanted pages from the print area.

Print Only the First Page in Google Sheets

You can achieve the same in Google Sheets with a slightly different approach. Let’s use the following example, which has too many rows and needs to be split into several pages when printing.

google sheets print one page initial data 1

  1. To print the sheet, go to File in the Menu, and click Print. (You can also use the keyboard shortcut CTRL + P).

google sheets print 1

  1. In the print screen, leave the default settings for now and click Next.

google sheets print all 1

  1. In the next screen, set Pages to Custom and set Page 1 to print.

google sheets print one page 1

As a result, the preview shows only the first page. You could also set any other page(s) you want to print using these settings.

AI Formula Generator

Try for Free

See all How-To Articles