See all How-To Articles

Center Worksheets Horizontally and Vertically in Excel & Google Sheets

In this article, you will learn 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

 

2. The Page Setup window will appear. Under Center on page, choose both Horizontally and Vertically.

 

center worksheet horizontally vertically 2

 

3. To see final results, in the Ribbon, click on File, and from the drop-down menu choose Print (or use the CTRL + P shortcut).

 

center worksheet horizontally vertically 5

 

Step 3 opens the Print Preview window. 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, click on File and from the drop-down menu, choose Print.

 

center worksheet horizontally vertically 5

 

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

 

center worksheet horizontally vertically 6

 

3. 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 will be 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 a bit different.

1. In the Toolbar, click on File, and from the drop-down menu, choose Print (or use CTRL + P shortcut).

 

change orientation worksheet landscape 16

 

2. In Print Settings, under Alignment, for Horizontal and Vertical choose Center.

 

center worksheet horizontally vertically 7

 

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

 

center worksheet horizontally vertically 9