![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://cxcs.microsoft.net/static/public/surface-and-devices/neutral/4873755a-8b1e-497e-bc54-101d1e75d3e7/d07c07fd6aabfe12ed716e87301dc3a1a3a7b5b0.png)
Try it!
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.
-
Select Format > Row Width.
-
Type the row width and select OK.
Resize columns
-
Select a column or a range of columns.
-
Select Format > Column Width.
-
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.