How to edit the cell size in Google Sheets

You can watch a video tutorial here.

Cells in Google Sheets are, by default, a uniform size. When formatting a spreadsheet, you may need to change the size of a cell or cells so that the text is properly displayed. 

Option 1 – Use the column and row headers

Step 1 – Increase the width

  • Move the cursor to the line that borders the column
  • When the cursor changes to a double-ended arrow, either double-click or drag the line to the desired width

Step 2 – Increase the height

  • Move the cursor to the line that borders the row
  • When the cursor changes to a double-ended arrow, either double-click or drag the line to the desired height

Step 3 – View the result

  • The size of the cell increases and the text is displayed properly

Option 2 – Use the context menu 

Step 1 – Select the rows

  • Select the row or rows containing the cells whose size is to be edited 
  • Right-click and select Resize rows from the context menu

Step 2 – Edit the row height

  • In the box, select Fit to data
  • Click OK

Step 3 – Select the column

  • Select the column containing the cells whose size is to be edited
  • Right-click and select Resize Column from the context menu

Step 4 – Enter the column width

  • In the box, increase the width of the column to 200
  • Click OK 

Step 5 – View the result

  • The size of the cells is increased