How To Change Cell Size In Google Sheets

Google Sheets, part of Google’s Drive suite, has become a powerful tool when it comes to online collaborative spreadsheets. It lets you create, edit, and collaborate with others on spreadsheets from your web browser. However, while working with Google Sheets, you might need to adjust the cell sizes for various reasons. Today, we’ll show you how you can change the cell size in Google Sheets.

Adjusting Cell Width

To change the cell width in Google Sheets, follow these easy steps:

  1. Click on the letter of the column you want to adjust. It will highlight the entire column.
  2. Move your cursor to the end of the column letter cell until it turns into a double-headed arrow.
  3. Click and hold down the mouse button, then drag it left or right to adjust the column’s width.

Adjusting Cell Height

Changing the cell height is quite similar to changing the cell width. Here’s how you can do it:

  1. Click on the number of the row you want to adjust. This will select the entire row.
  2. Move your cursor to the bottom of the row number cell until it turns into a double-headed arrow.
  3. Click and hold down the mouse button, then drag it up or down to adjust the row’s height.

Adjusting Cell Size Using a Specific Value

If you want your cell size to be precise, Google Sheets allows you to set the row height or column width to a specific value. Here are the steps:

  1. Select the rows or columns you wish to resize.
  2. Right-click the highlighted cells and select ‘Resize rows’ or ‘Resize columns’.
  3. In the dialog box that appears, enter the desired pixel size and click ‘Ok’.

Setting the Same Size for Multiple Cells

If you want to set the same size for multiple cells, you can use the following steps:

  1. Select the first cell in the range that you want to resize.
  2. Hold down Shift and select the last cell in the range. This selects all cells between the two you clicked.
  3. Follow the steps as described above to adjust the size of all selected cells at once.


The ability to adjust cell sizes in Google Sheets offers greater flexibility and control over your data presentation. By following the above steps, you can easily adjust the cell size according to your needs. Remember, managing your data effectively is a key aspect of any data-driven project.