Fitting enough information into a single cell is incredibly important when it comes to understanding what the cell is trying to tell us. The data can get compressed or cut off within a column, so you may need to change the column width. Luckily, Google Sheets makes it easy.
Changing column width is just one of the ways to format data within Google Sheets. It is useful for making data fit into the cell and for making the dimensions of any given table fit into a design or page.
Change Column Width in Google Sheets
You have a couple options when changing column width in Google Sheets. You can widen the column or make it more narrow. There are different ways of doing each of those.
Manually Widen Column Width
The easiest way to get a table just so is to manually set your column width.
- Open your Google Sheet and select the column you want to edit.
- Click the line on the right side column header. The mouse cursor should change into a double arrow.
- Drag the line until the column is wide enough for your needs and let go of the mouse.
Manually Narrow Column Width
As you would expect, to make the column narrower, you just do the opposite of the above.
- Open your Google Sheet and select the column you want to edit.
- Click the line on the right of the column header. The mouse cursor will change into a double arrow.
- Drag the line until the column is narrow enough for the data to fit and let go of the mouse.
You can manipulate column width incrementally until it is exactly right for what you need.
Automatically widen column width
If you are just looking to fit the data within the cells to the correct width so they can be read clearly, you can do that much faster than dragging the column width.
- Open your Google Sheet and select the column you want to edit.
- Hover over the line on the right side column header. The mouse cursor will change into a double arrow.
- Double click the line and it will automatically scale to fit the widest cell content.
</…….
Source: https://www.alphr.com/change-column-width-google-sheets/