How to Print in the Middle of the Page in Google Sheets

To print in the middle of the page in Google Sheets, press Ctrl + P (Cmd + P on a Mac) to open print settings, expand Formatting, and set Alignment to Center horizontally and Middle vertically. The preview updates straight away, so you can check the result before clicking Next.

Steps to Center a Printout in Google Sheets

  1. Open the spreadsheet in a browser and select the range you want to print, if it isn’t the whole sheet.
  2. Choose File > Print or press Ctrl + P.
  3. Under Print, pick Current sheet, Workbook or Selected cells.
  4. Expand Formatting.
  5. Under Alignment, set Horizontal to Center and Vertical to Middle.
  6. Click Next, then print or save as PDF.
Spreadsheet print settings with Alignment set to Center horizontally and Middle vertically
Center plus Middle places a small table in the middle of the page.

Can I center only horizontally?

Yes. Set Horizontal to Center and leave Vertical at Top.

Settings That Help a Centered Printout

Setting Where Why it helps
Scale: Fit to width or Fit to page Print settings Stops a wide table spilling onto a second page
Page orientation Print settings Landscape suits wide tables
Margins Print settings Equal margins keep the centering even
Show gridlines Formatting Turn off for a cleaner look

Does Google Sheets remember the alignment?

Print settings are tied to the sheet, but check the preview each time; if they reset, set Alignment again.

Centering several tabs in one go starts with the Workbook range, covered in printing a whole Google Sheets workbook.

The same print panel can also add numbering, and putting page numbers at the top in Google Sheets shows how to move them into the header.

If the Printout Won’t Sit in the Middle

  • Printout still sits in the top-left: Empty cells with formatting may be included in the print area. Choose Selected cells, or clear formatting from unused rows and columns.
  • Want text centered inside cells instead? That’s cell alignment, not page alignment. See centering across a selection in Google Sheets.
  • Hidden rows printing oddly: Hidden rows don’t print, which can shift the layout. See hiding rows in Google Sheets.
  • Option missing in the mobile app: Full print settings are in the browser version.