How To Center Text In Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to center text in Google Sheets.

By default, text in Google Sheets is left-aligned, while numbers and dates are right-aligned.

This alignment is usually fine for data processing purposes, but if you want to ensure that your spreadsheet looks good and is easy to read, you’ll often want to center align text or other values in Google Sheets. Fortunately you can quickly center all text in a given cell or range in a couple clicks.

Step 1

Select the cell or range you want to center. Note that all values in all selected cells will be centered, including numbers, dates and any other data format, in addition to plain text

Step 2

Click on the Horizontal Align icon in the toolbar, then choose the Center option from the mini menu that appears

Step 3

The text in the selected cell or range will be centered

Step 4

Repeat Steps 1-2 as needed to center all desired cells


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to center text in Google Sheets. Want more? Check out all the Google Sheets Tutorials.