Width and Height in Cells in Excel

Change Width and Height in Row and Columns in Excel




Change the Column Width:

You can make a column of data easier to read by adjusting the column width. For example, if you have a large number or a long line of text in a cell, Excel may display only part of the cell value. To avoid this, you can increase the width of the column. Similarly, if a column only contains a few characters in each cell, you can decrease the width to fit more columns on the screen.

Change the Row Height:

You can make your worksheet more visually appealing by increasing the row heights to create more space. This is particularly useful in worksheets that are crowded with text. By increasing the row heights, you add white space above each cell, which makes the text easier to read. If you want to change the row height to display multiline text within a cell, you must also turn on text wrapping within the cell. See “Wrap Text Within a Cell” later in this chapter.

Wrap Text Within a Cell:

You can make a long cell entry easier to read by wrapping the text within the cell. If you type more text in a cell than can fit horizontally, Excel either displays the text over the next cell if that cell is empty, or Excel displays only part of the text if the next cell contains data. To prevent Excel from showing only truncated cell data, you can format the cell to wrap text within the cell. In most cases, Excel increases the row height just enough so that it can display all the text given the cell’s current width.