Spreadsheets

Export one tab of a Google Sheet to PDF with the right page setup

Export one tab of a Google Sheet to PDF: choose the current sheet, landscape, fit to width, hide gridlines and repeat frozen rows for a clean result.

Editorial illustration for Export one tab of a Google Sheet to PDF with the right page setup

To save one tab of a Google Sheet as a PDF, open the print screen with Ctrl and P, choose Current sheet under Print, set Landscape and Fit to width, untick gridlines, tick Repeat frozen rows, then continue and save as PDF. The same settings appear under File, Download, PDF. Here is each choice in the order you meet it.

How do you export only one tab?

Open the tab you want. Go to File, then Print, or press Ctrl and P. On the right, find the Print setting at the top. It offers Current sheet, Workbook and, if you highlighted cells before opening, Selected cells. Pick Current sheet for a whole tab. Pick Selected cells if you only want a table inside it. If you leave it on Workbook you will get every tab in one file.

Which page settings give a clean result?

SettingChooseWhy
Paper sizeA4Check it, because the default may be Letter
OrientationLandscapeWide tables stay readable
ScaleFit to widthSqueezes all columns onto one page width
MarginsNarrow or NormalMore room for the data
Page orderDown, then overNatural for long lists

Fit to width scales down to make columns fit, so very wide sheets can end up with tiny text. If that happens, hide a few columns you do not need, or set the scale to Custom number and try 80 or 90 percent.

How do you tidy the look?

  • Under Formatting, untick Show gridlines if you want a clean page, or leave them on for a ledger look.
  • Choose whether cell notes are printed.
  • Under Alignment, choose Horizontal alignment if you want the table centred on the page.

Can you repeat the heading on every page?

Yes, if you froze the row first. Close the print screen, click View, Freeze and choose 1 row. Reopen Print, open Headers and footers and tick Repeat frozen rows. Each page of the PDF then starts with your column names. Without a frozen row this option has nothing to repeat.

How do you save the PDF itself?

Click Next at the top right of the print screen. In the box that follows, choose Save as PDF as the destination if you opened it from the browser's print dialog. On many setups, the File, Download, PDF route skips this and downloads a file straight away, with the same page settings shown first. Give the file a name that includes the month and the contents, such as Expenses-October-2026.

What if the PDF looks wrong?

  • Text too small: switch to Custom number scale, or hide columns.
  • A column on its own page: reduce margins or hide a column.
  • Sheet is cut at the bottom: check you picked Current sheet and not a stale selection.
  • Numbers show hash signs: widen the column in the sheet before exporting.

A last check before you send it

  1. Open the downloaded PDF and read page 1 and the last page.
  2. Check that totals are visible and the header repeats.
  3. Remove personal details you do not want to share, such as account numbers or phone numbers.

How do you send a PDF of only part of the sheet?

Highlight the range first, then open print and choose Selected cells. This is handy for a summary table at the top of a working tab. Extra rows below it are left out, so the file holds only what you meant to share. If the same range is needed every month, give it a named range through Data, Named ranges, so you can select it again in one click.

If you share expense reports often, SpendixAI can produce a ready-made report or a CSV download, which you can open in Sheets and export with the steps above.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports