In Google Sheets click on the column letter at the top of the sheet. This will select it.
In our example we need to adjust the width of cell B5 as the name is too long for the cell width. Note we have selected the column labelled B to select it.
2. Right Click on the Column and Choose Resize column
With the column selected right click, this will display a pop up menu. From the pop up menu select the Resize column option.
3. Specify the Column Width
From the Pop-Up window you will now see two options:
Enter new column width in pixels. (Default: 100)
This allows a specific value to be entered, selecting a larger amount will make the column and therefore the cells within bigger.
Fit to data
This option will automatically adjust the column to contain the data of the widest cell.
In our example we will specify a new column width. We need to make the width bigger so we will enter 140 which is a value that is bigger than the default value of 120.
4. Select OK to see the Results
With the custom width entered select OK and see the column has been resized to the custom width. In our example we can now see that cell B5 is now wide enough to contain the data.
How to Resize Multiple Cells in Google Sheets
1. Select the Desired Rows or Columns
Click on the column letter or row number to highlight all cells in the row or column
To select multiple rows or columns in Google Sheets hold the Ctrl key (cmd ⌘ key in Mac) when selecting.
In our example as we have multiple cells that appear too large we need to select multiple rows.
2. Right Click on the Last Selected Label
Right click on the label of the column or row selected last in the previous step to display a pop up menu. Select Resize the selected … (rows or columns)
3. Specify the Row Size
In the Pop-Up window you will now see two options:
Specify Row Height:
This allows a specific value to be entered, selecting a lower amount will make the row smaller and therefore the cells within smaller.
Fit to data:
This option will automatically alter the row height to contain the data of the highest cell.
In our example we will specify a new row height. We need to make the height smaller so we will enter 60 which is a value that is smaller than the original row height.
4. Select OK to see the Results
With the custom width entered select OK and you can now see the row has been resized to the custom width.
Resize Using the Click and Drag Method in Google Sheets
In Google Sheets we can use an alternative method to change the size of cells efficiently by a click and drag method.
1. Select the Desired Rows or Columns.
In your sheet click on the column or row labels to select all cells in the column or row.
To select multiple rows or columns hold the Ctrl key (cmd ⌘ key in Mac) when selecting.
In our example we will amend the width of column D to better match the width of the data.
2. Hover the Mouse Between Column or Row Labels
Hover the mouse icon between the end of the target column or row number and the next row or column. Notice the icon changes to the double arrow symbol ↔ Double clicking at this time will set the column or row to automatically fit to the data however in this example we will amend the width to our specification.
3. Click and Drag the Row/Column to the Desired Size
Click and drag the icon, you will see a blue line appear indicating the new size.
4. Release to Confirm the New Size
When the size is as required simply release the left click to confirm, the column or row will be resized.