Reduce Cell Text Size
You can automatically reduce text size to fit inside a spreadsheet cell. This eliminates the need to resize the column width and prevents text from being cut off when it exceeds the cell width.
-
Inside the spreadsheet, select a single cell, multiple cells, or all cells.
-
Right-click on the selected cells and select Format Cells.
-
Click the Alignment tab.
-
Select the Shrink to fit checkbox.
-
Click OK.