In this article:

How to Make Cells Bigger in Google Sheets [Best Method for 2024]

May 8, 2024

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:

How to Make Single Cells Bigger in Google Sheets

While it is not possible to make just a single cell bigger, we can resize the row or column that it contains.

Step 1: Click the Row Header for a Cell you want to make bigger 

Click the Row header of the cell you want to change to highlight it. 

In this example, number 5.

Highlighted row Selected in Google Sheets

 

Step 2: Hover The Cursor below the Selected Row 

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.

Arrow Cursor to resize the highlighted row in Google Sheets

Step 3: Drag Cursor down to increase the Cell size 

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.

Cell being Resized in Google Sheets

Step 4: Release Cursor to Resize Cell

When you have decided on how big you want your cell to be, release the cursor and it will be resized.

Cell made bigger in Google Sheets

How to Make Cells Bigger in Google Sheets (Multiple Cells)

Step 1: Hold Command ⌘ + Click (Mac) or CTRL + Click (Windows) to Highlight Target Rows

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

Making multiple cells larger in Google Sheets 

Step 2: Hover The Cursor below a Selected Row 

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.

Arrow Cursor to resize the highlighted rows in Google Sheets

Step 3: Drag Cursor down to increase the Cell sizes

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.

Multiple Cells being Resized in Google Sheets

Step 4: Release Cursor to Resize Cells

When you have decided on how large you want these cells to be, release the cursor and they will be resized together.

Cells made bigger in Google Sheets.

In this article we demonstrated the application of how to make cells bigger in Google Sheets.

Other Ways to Change Cell Size

How to Make all Cells the Same Size in Google Sheets

Standardize your spreadsheet by making every cell the exact same size.

How to Change Cell Height in Google Sheets

Learn how to edit the height of your cells without changing their width.

How to Change Cell Size in Google Sheets

Learn how to edit the cell size, making cells both smaller and bigger depending on your need.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->