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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access