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.
Quick Answer
File > Print > Formatting > Alignment: Horizontal = Center, Vertical = Middle > 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.
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 |
Troubleshooting
- 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.
Frequently Asked Questions
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.
Can I center only horizontally?
Yes. Set Horizontal to Center and leave Vertical at Top.
How do I print one page in the middle of a large sheet?
Select the cells, choose Selected cells in print settings, then set the alignment.
Summary
- Open File > Print.
- Choose what to print.
- Expand Formatting.
- Set Alignment to Center and Middle.
- Adjust scale and margins, then click Next.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.