In this article we will show you exactly how to make cells bigger in Google Sheets for both single and multiple cells. Just follow the simple steps below:
For the purposes of this demonstration a sample sheet was created. Access this sheet by clicking here and following along:
While it is not possible to make just a single cell bigger, we can resize the row or column that it contains.
Click the Row header of the cell you want to change to highlight it.
In this example, number 5.
Hover the Cursor below the selected row until the icon changes to two arrows, one pointing up and the other down. Left click and hold when this icon appears.
With the arrow icon clicked and held down, drag the bottom of the cell down. A line will appear that will indicate how big the cells will now become.
When you have decided on how big you want your cell to be, release the cursor and it will be resized.
To change multiple cell sizes, firstly select a row header then hold the ⌘ key down on a Mac ( CTRL on Windows) and select the others header rows you want to highlight. In this case we have selected row numbers 6 and 12
Hover the Cursor below either of the selected rows until the icon changes to two arrows. Left click and hold down when this icon appears.
With the arrow icon clicked and held down, drag the bottom of the cell down. A line will appear that will indicate how big the cells will now become. This can be done on either of the selected header cells.
When you have decided on how large you want these cells to be, release the cursor and they will be resized together.
In this article we demonstrated the application of how to make cells bigger in Google Sheets.
Standardize your spreadsheet by making every cell the exact same size.
Learn how to edit the height of your cells without changing their width.
Learn how to edit the cell size, making cells both smaller and bigger depending on your need.
