Adjust width and height cells Excel

Excel is a handy program to keep track of data. From household books to overviews of schedules. By default, Excel’s cells have a fixed width. If there is more information in a cell, it is not easily readable. You have to click on the cell to see exactly what it contains in the formula bar. This can be solved by automatically determining the row height and column width in an existing document. That means the columns will be as wide as the ‘widest text’ and the rows will be as tall as the tallest row content. A handy way to better see what’s in an Excel document.

Adjust the width and height of the cells in Excel like this:

• Launch Excel.
• Open the file whose cell height and column width you want to adjust automatically.
• Click on the triangle at the top left of the table. You’ll see it on the corner between column A and row 1. The entire table is now selected.
• If necessary, click on the tab Start.
• In the ‘Cells’ group, click the button layout.
• Click on the drop-down menu Ride Height AutoAdjust.
• Click the button again layout.
• Click on the drop-down menu AutoFit Column Width.