Column Width & Row Height

If the data you enter into a cell doesn't fit, you can make the column wider to accommodate all the characters. You can also make columns narrower to use worksheet space more efficiently. And although Excel automatically adjusts row height when you increase the font size of cells within the row, you can increase or decrease row height as desired.

Excel offers two ways to change column width and row height: with the mouse and with Format menu commands.

Tips

  • If text typed into a cell does not fit, it appears to overlap into the cell to its right (Figure 60). Even though the text may appear to be in more than one cell, all of the text is really in the cell in which you typed it. (You can see for yourself by clicking in ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.