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