See all How-To Articles

Center Worksheets Horizontally and Vertically in Excel & Google Sheets

This tutorial demonstrates how to center worksheets horizontally and vertically in Excel and Google Sheets.

center worksheet horizontally vertically 4

Center Worksheets Horizontally and Vertically

Center via Page Layout

  1. First, select the data you want to print and set the print area.
  2. To center the worksheet horizontally and vertically on the page, in the Ribbon, go to Page Layout > Margins > Custom Margins.

center worksheet horizontally vertically 1

  1. The Page Setup window appears. Under Center on page, choose both Horizontally and Vertically.

center worksheet horizontally vertically 2

  1. To see the final result, in the Ribbon, go to File > Print (or use the CTRL + P shortcut).

center worksheet horizontally vertically 5

Step 4 opens Print Preview. In that view, you can see how your worksheet will look when it’s printed. As a result of the steps above, the selected print area is positioned in the center.

center worksheet horizontally vertically 3

Center Using Print Preview

Another option to center a worksheet for printing is to start from Print Preview.

  1. In the Ribbon, go to File > Print.

center worksheet horizontally vertically 5

  1. In Print settings, click Normal Margins (this is chosen by default) and from the drop down, choose Custom Margins.

center worksheet horizontally vertically 6

  1. This opens the Page Setup window. Under the Center on page section, choose both Horizontally and Vertically to center the selected print area.

center worksheet horizontally vertically 2

As a result, the selected print area is centered on the worksheet.

center worksheet horizontally vertically 3

Note: To apply this print layout on multiple sheets at the same time, just select all the sheets you need, then follow the steps above.

Center Worksheets in Google Sheets

Centering a worksheet horizontally and vertically in Google Sheets looks works a bit differently.

  1. In the Menu, go to File > Print (or use the CTRL + P shortcut).

change orientation worksheet landscape 16

  1. In Print settings, under Alignment, choose Center for both Horizontal and Vertical.

center worksheet horizontally vertically 7

As a result, the print area is positioned in the center of the worksheet.

center worksheet horizontally vertically 9

See all How-To Articles