This tutorial demonstrates how to delete unwanted pages and print only the first page in Excel and Google Sheets.
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.
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 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.
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.
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.
In Print Preview, you can see that only the first page is set for printing.
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.
- To print the sheet, go to File in the Menu, and click Print. (You can also use the keyboard shortcut CTRL + P).
- In the print screen, leave the default settings for now and click Next.
- In the next screen, set Pages to Custom and set Page 1 to print.
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.