You can manually adjust the column width or row height or automatically resize columns and rows to fit the data.
Note:The boundary is the line between cells, columns, and rows. If a column is too narrow to display the data, you will see ### in the cell.
Resize rows
-
Select a row or a range of rows.
-
On the Home tab, select Format > Row Width(or Row Height).
-
Type the row width and select OK.
Resize columns
-
Select a column or a range of columns.
-
On the Home tab, select Format > Column Width (or Column Height).
-
Type the column width and select OK.
Automatically resize all columns and rows to fit the data
-
Select the Select All button at the top of the worksheet, to select all columns and rows.
-
Double-click a boundary. All columns or rows resize to fit the data.
Need more help?
You can always ask an expert in the Excel Tech Communityor get support inCommunities.