How To Make Cells Bigger In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to make cells bigger in google sheets.

The default cell size in Google Sheets works well for short values like numbers, but certain data such as text descriptions or text in enlarged fonts sometimes overflow the cells.

Additionally, one might want to enlarge spreadsheet cells to achieve a certain look or layout for stylistic reasons.

Auto-Fit Column Width to Data

The quickest way to resize cells so your data displays nicely in them is to auto-fit the column width to cell contents. Here’s how:

Step 1

Locate the column header for the column you want to auto-fit to data. For example, column A in the screenshot below

Step 2

Hover your mouse over the right edge of the column you want to resize and you’ll see a blue highlight appear and your cursor change to a double-pointed resizing arrow

Step 3

Without moving your mouse, double click on the highlighted boundary. The column will automatically resize to fit the data it contains

Manually Resize Columns

If the above method doesn’t give you the result you’re expecting or you want greater control over the exact size of your columns, follow these steps to manually set column width:

Step 1

Select the column or columns you wish to resize, then right-click on the column header

Step 2

Choose Resize Columns from the right-click menu

Step 3

In the Resize Column popup, enter the new column width in pixels then click OK

Step 4

The selected columns will be resized

Manually Resize Rows

You can also set row height in Google Sheets using the same steps as above but right clicking on the row numbers instead of the column headers and choosing Resize Rows

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to make cells bigger in google sheets. Want more? Check out all the Google Sheets Tutorials.