Formatting - Text Formatting

There are time you just want to squeeze everything into one cell. Other than adjusting the column width, you could reduce the font size either manually or automatically. To do it automatically, go to format cells (Ctrl 1), select Alignment, and at Text Control, click on Shrink to Fit & you're done. If you don't want to change the font size but you don't mind a higher row height, then choose Wrap Text instead and automatically the row height will be adjusted.