See all How-To Articles

Make Cells Bigger to Fit Text in Excel & Google Sheets

In this tutorial, you will learn how to automatically size cells in order to fit text in Excel and Google Sheets.

 

fit text in cell excel 1

 

Sometimes when using Excel, you will need to resize a cell’s width or height in order to fit all the text in the cell. You can do it manually by setting the width and height or use AutoFit options in Excel. There are two ways to autofit width or height to fully display text. The first option is to double-click and the second is to use the AutoFit options in the Ribbon.

AutoFit by Double-Clicking

AutoFit is an Excel feature that adjusts the width of a column to fit its contents. Say you have a range of cells where the data doesn’t fit, so the content of the cells is not displayed fully.

 

autofit text in cell initial data 2

 

As you can see, data in Columns B, C, and D are not displayed fully. The columns are not wide enough. To autofit Column C (Name), first position your cursor between the headings for Columns C and D. When the cursor changes to a double-sided arrow, double-click.

 

autofit column width 1

 

As a result, Column C is expanded in a way that the longest text in the column fits the cell. In this case, the width is based on cell C3.

Note that when numbers don’t fit the cell, they are displayed as hash (#) symbols.

 

autofit column width 2a

 

AutoFit Multiple Columns’ Widths

Similar to the previous example, you can autofit multiple columns at once.

1. Select the entire columns that you want to expand (B, C, and D), then position your cursor between any of the selected columns’ headings (for example between B and C).

2. When the cursor changes to a double-sided arrow, double-click.

 

autofit multiple columns width 1

 

As a result, all selected columns are expanded to autofit text, based on the longest text in the column.

 

autofit multiple columns width 2a

 

NOTE: You also have the option, instead of automatically increasing the cell size, to automatically shrink the text.

AutoFit Row Height

Similarly, you can also autofit single or multiple rows’ heights. Say you want to autofit Row 1’s height, as it’s too high for the content. First, position your cursor between the headings for Rows 1 and 2, and when the double-sided arrow cursor appears, double-click.

 

autofit row height 1

 

As a result, Row 1 height is reduced, so the text fits.

 

autofit row height 2a

 

AutoFit Option in the Ribbon

Another way to autofit the column width is to use the AutoFit option in the Ribbon.

To do this, select the entire columns that you want to autofit (B, C, and D). Then in the Ribbon, go to Home > Format > AutoFit Column Width.

 

autofit row height ribbon 1

 

The result is the same as using the double-click method: All three columns are expanded to fit the text.

 

autofit row height 2a

 

AutoFit Row Height

Similarly, you can also autofit single or multiple rows’ heights. Say you want to autofit Row 2’s height, as it’s too high for the content.

First, select the row whose height you want to autofit. Then in the Ribbon, go to the Home > Format > AutoFit Row Height.

 

autofit row height ribbon 2a

 

As a result, Row 1’s height is reduced, so the text fits.

 

autofit row height 2a

 

AutoFit in Google Sheets

The only way to autofit cells in Google Sheets is to double-click. Double-clicking works exactly the same as in Excel for single or multiple rows or columns.