In this article:

How to Center Text in Google Sheets (2024 Update)

March 25, 2024

In this article, we explain how to center text in Google Sheets. Simply follow the steps below!

How to Center Text in Google Sheets

To center text in Google Sheets, follow these steps:

Step 1: Select the Cells

Click on the cell where you want to center the text. If you want to center text in multiple cells, click and drag your mouse to select all the desired cells.

Step 2: Find the Text Alignment Options

Look for the toolbar at the top of the page. You will find text alignment options there.

how to center text in google sheets

Step 3: Center Text Horizontally

Click on the "Center Align" button (represented by an icon with centered lines) in the toolbar. This will center your text horizontally within the selected cells.

center text in google sheets

Step 4: Center Text Vertically (Optional)

Next to the horizontal alignment buttons, there should be vertical alignment options. Click on the "Middle Align" button (usually represented by an icon with lines aligned to the middle) to center your text vertically within the cell.

google sheets center text

Now the text in your selected cells should be centered both horizontally and vertically. Remember, these changes will apply to all the cells you have selected.

We hope that this article has helped you and given you a better understanding of how to center text in Google Sheets. If you enjoyed this article, you might also like our articles on how to get data from a website in Google Sheets and how to enable Google Sheets iterative calculation.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->