Need help setting this up?
If you'd rather not deal with the technical side, we can fully set up and manage your Microsoft 365 for you — including email, DNS, and ongoing support.
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.
Related Guides
- Split text into different columns with the Convert Text to Columns Wizard
- Import or export text (.txt or .csv) files
- Insert or delete cells, rows, and columns
- Collaborate on Word documents with real-time co-authoring
- OneDrive basics
Prefer us to handle this?
We provide fully managed Microsoft 365 setup and support — so you can focus on running your business.
