Adapt Columns Text For Free

To adjust a column, select it, and then select Layout > AutoFit > AutoFit Contents. To adjust a table, select it, and then select Layout > AutoFit > AutoFit Contents.

Adjust text to fit within an Excel cellSelect the cell with text that's too long to fully display, and press Ctrl1.In the Format Cells dialog box, select the Shrink To Fit check box on the Alignment tab, and click OK.23 Aug 2005

Resize a column or table automatically with AutoFitSelect your table.On the Layout tab, in the Cell Size group, click AutoFit.Do one of the following. To adjust column width automatically, click AutoFit Contents. To adjust table width automatically, click AutoFit Window.

Wrap text automatically On the Home tab, in the Alignment group, click Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.) Notes: Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.

Change the column width to automatically fit the contents (AutoFit)Select the column or columns that you want to change.On the Home tab, in the Cells group, click Format.Under Cell Size, click AutoFit Column Width.

2. Use a Keyboard Shortcut to Make Excel Cells Expand to Fit Text AutomaticallySelect the column whose cells you want to expand to fit cells. Now press Alt+H+O+I on the keyboard.If you have to fix your column height you can do it using keyboard shortcuts too. Select the columns you want to fit text automatically.

Select any cell in the column/row you want to autofit:To autofit multiple non-adjacent columns/rows, select one column or row and hold down the Ctrl key while selecting the other columns or rows.To autofit the entire sheet, press Ctrl + A or click the Select All button.Mar 16, 2017