In Excel column width can be modified, as can row height and width in Excel. Learn to modify Excel cells in this free Excel 2016 lesson.
By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells.
Optional: Download our practice workbook.
Watch the video below to learn more about modifying columns, rows, and cells.
In our example below, column C is too narrow to display all of the content in these cells. We can make all of this content visible by changing the width of column C.
With numerical data, the cell will display pound signs (#######) if the column is too narrow. Simply increase the column width to make the data visible.
The AutoFit feature will allow you to set a column's width to fit its content automatically.
You can also AutoFit the width for several columns at the same time. Simply select the columns you want to AutoFit, then select the AutoFit Column Width command from the Format drop-down menu on the Home tab. This method can also be used for row height.