How to☝️ Center Across Selection in Google Sheets

To center across selection in Google Sheets, highlight the cells, navigate to the toolbar, select Merge cells, and choose the Merge all option. Then go to the Horizontal align icon and pick Center. Next, click on the Vertical align icon and choose the Middle type. Finally, go to the Text rotation option and click on the alignment you need.

The purpose of this article is to show you how to center text across a selection in Google Sheets in just a few seconds.

Follow along and you will see a step-by-step description with illustrations to help you use this method in your own worksheet.

The Quick and Easy Way to Center Across Selection

Learn how to center across selection in a few steps with this easy guide:

Difficulty: Beginner

Time Estimate: 10 seconds

  1. Select the cells you want to merge.
  2. Go to the toolbar and click on the Merge cells icon.
  3. Pick the type of merge you need. Here we use the Merge all option. 

The Quick and Easy Way to Center Across Selection

  1. Next, navigate to the Horizontal align icon on the toolbar.
  2. Press the Center option.

Horizontal align

Easy-peasy! Your text has been set to the central alignment!

Central alignment

If the height of your cell is not set by default and you want to change the placement of the text in it, use the following steps:

  1. Go to the toolbar and click on the Vertical align icon.
  2. Choose the Middle option. 

Vertical align

To change text rotation: 

  1. Choose the Text rotation option.
  2. Select the alignment you like. Here we use Stack Vertically.

Text rotation

Voila! Let’s take a look at our result!

Stack Vertically

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X