In Excel, you can manually modify the column width or row height or intuitively resize columns and rows to fit the data. This has the benefit of revealing the data that you want to see without missing any key information.
Applies to: Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010.
Note: The boundary is the line between cells, columns, and rows. However, it is important to note that if a column is too slim to reveal the full data, you will see ### in the cell.
- First, click a row or a range of rows.
- Next, choose Format > Row Width. See the Home tab, in the Cells group.
- Thirdly, define the row width. Then, press OK.
- First, pick a column or a range of columns.
- Second, click Format > Column Width. Next, check the Home tab, in the Cells group.
- Finally, set the column width. After this, press OK.
Automatically resize all columns and rows to fit the data
- Initially, choose the Select All button at the top of the worksheet. In effect, this will highlight all columns and rows.
- Next, double-click a boundary. As a result, all columns or rows increase their dimensions to fit the data.
Need more help?
Listed below are three avenues to resolving your queries and/or giving Excel an inspiration for better features or efficient ways of working.
- First and foremost, you can always ask an expert in the Excel Tech Community;
- Second, get support in the Answers community, or;
- On the other hand, you can suggest a new feature or improvement on Excel User Voice.