How to Center Data Horizontally in Google Sheets

To center data horizontally in Google Sheets, select the cells, click the Horizontal align button in the toolbar, and choose Center. You can also use Format > Alignment > Center, or press Ctrl + Shift + E (Command + Shift + E on a Mac). The text moves to the middle of each cell from left to right.

By default, Sheets aligns text to the left and numbers to the right, so centering is useful for headers and short values that should line up neatly.

Center Data With the Toolbar

  1. Select the cells. Click a column letter to select a whole column, or the box above row 1 for the whole sheet.
  2. Click Horizontal align in the toolbar (the icon with stacked lines).
  3. Choose the Center icon.
Online spreadsheet with a column selected and the horizontal align menu open with Center chosen
Horizontal align in the toolbar offers left, center, and right alignment.

Can I make centered alignment the default?

Not directly. Center the columns before you type, or copy the formatting with the Paint format tool.

Does centering change the data?

No. It only changes how values look, not the values themselves.

Alignment Shortcuts

Alignment Windows and ChromeOS Mac
Left Ctrl + Shift + L Command + Shift + L
Center Ctrl + Shift + E Command + Shift + E
Right Ctrl + Shift + R Command + Shift + R

Center Vertically Too

To put text in the middle of a tall cell, click Vertical align (next to Horizontal align) and choose Middle, or use Format > Alignment > Middle. Combine both for text that’s centered in every direction.

Center a Title Across Several Columns

To center one heading across columns A to E, select A1:E1 and use Format > Merge cells > Merge horizontally, then center it. Merged cells can make sorting and copying harder, so use them only for titles above your data.

Center Data in the Mobile App

  1. Tap the cells to select them.
  2. Tap the Format button (the A with lines).
  3. On the Text tab, tap the center alignment icon.

If Centering Looks Off

  • Numbers still look off-center: Different number formats have different widths. Apply the same format to the column, or use a monospaced number format.
  • The shortcut doesn’t work: A browser extension may be using it. Use the toolbar button instead.