The way to Match Textual content in Google Sheets

While you sort some textual content in a cell in Google Sheets, it is not going to robotically slot in it.

As an alternative, the textual content will exit of the cell and overflow to the subsequent column(s).

Sadly, there isn’t a shortcut for becoming/preserving textual content right into a cell.

Therefore, it is advisable to manually wrap the textual content to stop it from overflowing.

To match textual content in Google Sheets, you possibly can both wrap the textual content or resize the columns to suit the information.

Listed below are two strategies to suit textual content in Google Sheets.

Technique 1: Wrap textual content

The way to match textual content in Google Sheets by wrapping them:

1. Choose all the columns/rows (shift + click on).
2. Click on “Format” on the highest navigation bar.
3. Choose “Wrapping”.
4. Choose “Wrap”.

After you’ve chosen “Wrap”, the textual content within the columns (that you just’ve chosen) might be wrapped.

Wrapping will match/hold the textual content in a cell based mostly on the width of the column.

Therefore, the textual content is not going to overflow out of the cell.

In the event you’re writing in a brand new column, it is advisable to wrap the textual content in it once more.

Technique 2: Match to information

The way to match textual content in Google Sheets by becoming them to the information:

1. Choose all the columns/rows (shift + click on).
2. Proper-click a column/row.
3. Choose “Resize columns X – Y”.
4. Choose “Fit to data”.
5. Click on “OK” to save lots of your adjustments.

After you’ve chosen “Fit to data”, all textual content will slot in all cells.

Just like wrapping, the textual content will match based mostly on the width of every column.

You may edit the scale of a column by right-clicking it and clicking on “Resize columns”.

As an alternative of choosing “Fit to data”, choose “Enter new column width in pixels” and enter the width that you just wish to set for the column(s).

Additional studying

The way to Heart Textual content in The Center in Google Docs

The way to Take away Desk Borders in Google Docs

The way to Make Textual content Vertical in Google Docs