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

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

  1. Open your spreadsheet from Google Drive.
  2. Click the File tab.
  3. Choose the Print option.
  4. Select Formatting in the right column.
  5. Click the Vertical button.
  6. 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.

click the File tab

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.

choose the Print option

Step 4: Click the Formatting tab at the bottom of the right column.

expand the Formatting tab

Step 5: Scroll down and click the Vertical dropdown menu under Alignment.

click the Vertical option

Step 6: Select the Center option from the menu.

how to print in the middle of the page in Google Sheets

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.

Additional Reading