On the Horizontal pop-up menu, click the alignment that you want. In the Format Cells box, and in the Alignment tab, do any of the following:Ĭhange the horizontal alignment of the cell contents Select the cell or range of cells that contains the data that you want to reposition. You can change the alignment of the cell contents, use indentation for better spacing, or display the data at a different angle by rotating it. Reposition the contents of the cell by changing alignment or rotating textįor the optimal display of the data on your sheet, you may want to reposition the text in a cell. When you change the column width or enter more data, the font size adjusts automatically. In the Format Cells dialog box, select the checkbox next to Shrink to fit.ĭata in the cell reduces to fit the column width. If you enter more content into the cell, Excel will continue to reduce the font size. Reduce the font size to fit data in the cellĮxcel can reduce the font size to show all data in a cell. Inserting a line break may make text in a cell easier to read.Ĭlick where you want to insert a line break, and then press CONTROL + OPTION + RETURN. To enable the row to adjust automatically and show all wrapped text, on the Format menu, point to Row, and then click AutoFit. Note: If all wrapped text is not visible, it might be because the row is set to a specific height.