How to Center a Table in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on February 22, 2023

This tutorial demonstrates how to center a table in Excel and Google Sheets.


centertable intro


Center a Table

  1. Make sure your table is selected in Excel. (The Table Design tab should be visible on the Ribbon.)


centertable table


  1. Then, in the Ribbon, go to File > Print.


centertable backdoor view


  1. In the Settings drop down, choose Print Selected Table.


centertable select table


  1. Next, in the margins drop down, choose Custom Margins.


centertable custom margins


  1. This takes you to the Page Setup dialog box, Margins tab. Make sure that Center on page – both Horizontally and Vertically are ticked.


centertable center


Note: An alternate way to get to the Page Setup dialog box is to select Margins from the Page Layout tab in the Ribbon. Then, click OK to apply the settings. You should now see your table horizontally and vertically centered in Print Preview.

How to Center a Table in Google Sheets

  1. In the Menu, go to Print.


centertable gs print


  1. This opens Print Preview, displaying the sheet, with a pane of options displayed on the right side of the screen.


centertabl gs print settings


  1. In the Alignment section, make sure both Horizontal and Vertical are set to Center.


centertable gs formatting center


  1. The sheet is now centered both vertically and horizontally on the page.


centertable gs preview

AI Formula Generator

Try for Free

See all How-To Articles