Spreadsheets Expert

SpreadSheets Expert

How to Center Across Selection in Google Sheets?

Google Sheets is one of the most used applications for analyzing and presenting data. One of the features many people look for in Google Sheets is center across selection. Let’s learn how to center across selection in Google Sheets.

How to Center Across Selection in Google Sheets?

Sadly, Google Sheets does not have a center across selection feature like Excel. But there are alternate ways to achieve this thing in Google Sheets. Let’s learn those ways.

Method 1:

The first way to use center across selection is by using the feature of merge cells in Google Sheets.

  • First, select all the cells you want to show text in center align format.
  • Then click on the merge cells button, as shown below.

center cross-selection using Merge cells

center align center cross-selection

  • Next, click the “vertical-align” button and select “middle”.

vertical align center cross-selection

  • This way, you can center across selection in Google Sheets.

Method 2:

The second way to do center across selection is using spaces and Overflow features in Google Sheets.

  • First, enter the title you need to show in the center of the required cells.
  • Then click on Format –> Wrapping –> Overflow to allow the cell content to overflow from the cell area.

Center Across Selection in Google Sheets

  • Now, you have to add spaces before the text. This will move the text to the right side, crossing the cell’s right border.
  • Keep adding spaces until you want the text to reach your desired spot.
  • Once you are done, you will see that it worked as a center across selection.

Final Center Across Selection in Google Sheets

FAQ:

How do I center text horizontally in Google Sheets?

Follow the steps below to center text horizontally in Google Sheets.

  • First, select all the cells you want to show text in center align format.
  • Then click on the horizontal align button in the toolbar

Leave a Comment