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
- Open the spreadsheet in a browser and select the range you want to print, if it isn’t the whole sheet.
- Choose File > Print or press Ctrl + P.
- Under Print, pick Current sheet, Workbook or Selected cells.
- Expand Formatting.
- Under Alignment, set Horizontal to Center and Vertical to Middle.
- Click Next, then print or save as PDF.

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.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.