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:
Locate the column header for the column you want to auto-fit to data. For example, column A in the screenshot below
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
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:
Select the column or columns you wish to resize, then right-click on the column header
Choose Resize Columns from the right-click menu
In the Resize Column popup, enter the new column width in pixels then click OK
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
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.