Home Computer Repair How to Automatically Expand Cells in Excel

How to Automatically Expand Cells in Excel


When working with Excel worksheets, you’ll often need to adjust the size of the cells. Depending on how much data they hold, you can adjust both their width and height. Because Excel sheets consist of rows and columns, changing the width of your cell will affect that entire column. The same applies to the height of the rows.

To do this manually, simply drag the right border of the column header left or right. Column headers are located above the first row and marked with letters, starting with A.

When you want to change the height of a row, grab the lower border of the row header and drag it up or down. Row headers are marked with numbers, and you can find them to the left of column A.

Of course, Excel allows you to do all this automatically, thanks to the AutoFit option.