Changing Row Heights and Column Widths

When you create an Excel workbook, the default worksheet rows are tall enough to accommodate text and numbers entered in the standard character format (Calibri, 11 point) and wide enough to display about eight characters. If your text takes up too much space to fit in the cell (because you’ve changed the font size for a column label, for example), you can widen the column so that the contents of every cell can be seen. You can also increase the height of rows in your worksheet to put some space between values, which will make your data easier to read. If a column is too wide or a row is too high, you can make it narrower or shorter, as needed.

Resize a Row

  1. Hover the mouse pointer over the lower boundary of ...

Get Microsoft® Office Excel® 2007 Plain & Simple 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.