When you print a spreadsheet in Google Sheets it will align to the top of the page by default.
This setting is fairly standard, and it is the desired output for many types of spreadsheets.
But you might be creating something in Google Sheets that would look better if it were printed in the vertical center of the page.
Rather than adding a bunch of empty rows to the top of the spreadsheet, a more effective way to accomplish this is by changing the vertical alignment setting on the print menu.
Our guide below will show you how to print in the middle of the page in Google Sheets.
How to Set Center Vertical Alignment in Google Sheets
- Open your spreadsheet from Google Drive.
- Click the File tab.
- Choose the Print option.
- Select Formatting in the right column.
- Click the Vertical button.
- Choose the Center option.
Our article continues below with additional information and pictures for these steps.
How to Print in the Middle of the Page on Google Sheets (Guide with Pictures)
The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Firefox or Safari.
Step 1: Sign into Google Drive and open the Sheets file.
Step 2: Choose the File tab at the top-left of the window.
Step 3: Select the Print option at the bottom of the menu.
You can also open the Print menu with the shortcut Ctrl + P on your keyboard.
Step 4: Click the Formatting tab at the bottom of the right column.
Step 5: Scroll down and click the Vertical dropdown menu under Alignment.
Step 6: Select the Center option from the menu.
Note that you can also use the Horizontal alignment dropdown menu if you want to change the horizontal alignment of your data as well.
There are a number of other options on the formatting menu that you can use, too, such as adding page numbers, showing gridlines, or changing the page order.
- How to change the orientation of a printed spreadsheet in Google Sheets
- How to sort a column from high to low in Google Sheets
- How to print with gridlines in Google Sheets
- How to copy multiple rows in Google Sheets
- How to change cell border color in Google Sheets
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.