How To Make Cells The Same Size In Google Sheets

In this article, y'all 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'southward width or height in order to fit all the text in the cell. Yous can practise it manually by setting the row and tiptop or use AutoFit options in Excel. There are two means to autofit width or pinnacle to fully brandish text. The first option is to double-click and the second is to apply the AutoFit options in the Ribbon.

AutoFit by Double-Clicking

AutoFit is an Excel characteristic that adjusts the width of a column to fit its contents. Say you take 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 non displayed fully. The columns are non 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

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

Annotation 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 case, y'all can autofit multiple columns at once.

i. Select the entire columns that yous desire to expand (B, C, and D), then position your cursor betwixt whatsoever of the selected columns' headings (for case 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 cavalcade.

autofit multiple columns width 2a

Notation: Yous as well have the option, instead of automatically increasing the cell size, to automatically shrink the text.

AutoFit Row Height

Similarly, you lot can besides autofit single or multiple rows' heights. Say you lot desire to autofit Row 1's height, as it'southward also high for the content. First, position your cursor between the headings for Rows 1 and two, and when the double-sided pointer cursor appears, double-click.

autofit row height 1

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

autofit row height 2a

Using the AutoFit Selection in the Ribbon

Another fashion to autofit the cavalcade width is to use the AutoFit option in the Ribbon.

To practise this, select the unabridged columns that you lot desire 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 meridian, as it's as well high for the content.

Kickoff, select the row whose height yous want to autofit. And then in the Ribbon, go to the Habitation > Format > AutoFit Row Height.

autofit row height ribbon 2a

As a effect, Row ane's height is reduced, so the text fits.

autofit row height 2a

AutoFit in Google Sheets

The but mode to autofit cells in Google Sheets is to double-click. Double-clicking works exactly the same every bit in Excel for unmarried or multiple rows or columns.