Microsoft Excel Logo.

Using Microsoft Excel’s AutoFit feature, you can ensure that your content in your cells is always fully visible (without being cut off). Here’s how to use this option for specific rows and columns, and for your entire worksheets.

There are mainly two scenarios where you’ll use this feature. The first one is when your cell’s content is cut off due to the cell’s limited size. In this situation, AutoFit will increase the cell size so that your full content is visible all the time.

The other scenario is when you have a limited number of characters in your cell and you don’t need any extra space in the cell. In this case, AutoFit will decrease the cell size, which lets you see more content on your screen at any given time.

RELATED: How to Add Space Between Text and Cell Borders in Excel

Use AutoFit for Specific Columns or Rows in Excel

To increase or decrease the size of specific rows or columns, use this method.

First, launch your spreadsheet with Microsoft Excel. Then select the column or rows you’d like to autofit. You can make multiple selections by pressing and holding down the Ctrl (Windows) or Command (Mac) key.

Choose rows or columns.

Advertisement

After selecting your rows or columns, in Excel’s ribbon at the top, click the “Home” tab.

Select the "Home" tab at the top.

On the “Home” tab, in the “Cells” section, click the “Format” option.

Choose "Format" in the "Home" tab.

In the “Format” menu, if you’d like to autofit your columns, then choose the “AutoFit Column Width” option. To autofit your rows, then choose “AutoFit Row Height.”

Select an AutoFit option.

Excel will increase or decrease your rows or columns’ sizes to ensure the full content is visible.

Autofit column in Excel.

You’re all set.

Use AutoFit for an Entire Worksheet in Excel

If you have a large spreadsheet containing many rows and columns, you can apply AutoFit to your entire worksheet at once.

To do so, first, open your spreadsheet in Microsoft Excel. Then, at the bottom of your spreadsheet, click the worksheet in which you want to use AutoFit.

Choose a worksheet.

Advertisement

Once your worksheet opens, select the entire worksheet. Do so by clicking the “Select All” icon (a diagonally-pointed triangle) in the worksheet’s top-left corner. Alternatively, press Ctrl+A (Windows) or Command+A (Mac).

Note: If your keyboard shortcut only selects an area in the worksheet, press it again to select the entire worksheet.

Now that your full worksheet is selected, in Excel’s ribbon at the top, click the “Home” tab.

Access the "Home" tab in the ribbon.

On the “Home” tab, in the “Cells” section, click the “Format” menu.

Open the "Format" menu on the "Home" tab.

If you’d like to resize the columns in your worksheet, then from the “Format” menu, choose “AutoFit Column Width.” To resize all your rows, choose the “AutoFit Row Height” option.

Autofit an entire worksheet.

And Excel will make the requested changes to your spreadsheet. You’re all done.


On a similar note, you can also manually set the row and column size in Excel if you want. Check out our guide to learn how.

RELATED: How to Set Row Height and Column Width in Excel

Profile Photo for Mahesh Makvana Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips.
Read Full Bio »