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.
In our example below, some of the content in column A cannot be displayed. We can make all of this content visible by changing the width of column A.
If you see pound signs (#######) in a cell, it means the column is not wide enough to display the cell content. Simply increase the column width to show the cell content.
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.