For example, suppose a cell’s content in your data set is cut off due to the limited size. The AutoFit in Excel feature may increase the cell size and make your cell content visible all the time. Conversely, even when you have limited characters in your, and you do not require any extra space in the cell, the AutoFit feature can decrease the cell size and make your content noticeable at any time. 

Top 5 Methods to AutoFit in Excel

  • AutoFit using double click on the mouseAutoFit using the select-and-drop optionAutoFit using a menu with a few tabsAutofit using AutoFit row height buttonAutoFit using the Wrap Text button

Let us now discuss the method in detail with an example

Method #1 – AutoFit by Double Click on the Mouse

Method #2 – AutoFit using the Select and Drag Option

This feature is the same as AutoFit cell size. Using a mouse pointer with the selection and dragging can make the cells automatically fit the value base size.

  • In the MS Excel worksheet, move the mouse pointer in the middle of the A B cell line, as mentioned below. After that, we need to click twice using a mouse pointer in the middle of the AB cell line. Now, we can see the visibility of the entire value of the cell mentioned in the A column that automatically fits the value of a cell.

Now, we can see the visibility of the entire value of the cell mentioned in the A column that automatically fits the value of a cell.

Select the row/column you want to AutoFit cells in all versions of Excel without going through a menu.

We can see this feature of AutoFit. For example, in the illustration below, we could find that the “A” column of “SOLD BY” has names but does not show the complete names. So, here we will go for AutoFit adjustments.

  • Select the line of the “A” (i.e., SOLD BY) column in the worksheet, as mentioned in the below screenshot.

  • After that, we will drag the mouse pointer on the worksheet with the desired length of a cell value, as mentioned in the below screenshot.

Method #3 – AutoFit Using Menu with Few Tabs

This feature is the same as AutoFit, but the usage begins with a menu/buttons, either mouse selection or shortcut keys as you like it. We could use it further.

Here we go with minimal steps.

  • Select the rows/columns we want to AutoFit (if we need to AutoFit all rows and columns, click the top left box to select everything, or we can highlight multiple rows/columns by holding the “Ctrl” key and choosing each row/column).

  • Next, we will go to the “Home” menu and select the “Excel Format” button, as mentioned below.

  • Afterward, select “AutoFit Column Width” to complete the “AutoFit” action on desired cells.

  • Afterward, we need to click/select the “AutoFit Column Width” button. The chosen cell of A column will automatically extend the size of a cell.

Method #4 – Autofit Using AutoFit Row Height Button

  • We just selected one of the cells with two lines in the same cells in a worksheet. This cell has the “BANNERGHATTA DOMLUR” values but only shows BANNERGHATTA.

  • After selecting cells, we will go to the “Home” menu and select the “Format” button, as mentioned below.

  • After that, select AutoFit Excel Row height AutoFit Excel Row HeightThe Autofit Row Height feature in Excel automatically expands/narrows the row height based on the text in the cell.read more to complete the “AutoFit” action on desired cells.

  • Then, we will click/select the “AutoFit Row Height” button. The chosen cell of A column will automatically extend the size of a cell.

Tips: The same can be performed using the Wrap Text button.

Method #5 – AutoFit Using the WRAP TEXT Button

Whenever we want to adjust/align the row height or text wrap in a cell, we should click “Wrap Text.” Else, the height of a cell will be the height of the font of your text. If multiple rows or columns are highlighted when adjusting the width or height manually, all other highlighted rows and columns will change with their width/ height to the same value or content.

Some text is entered in column B, but the cell size is limited to the regular size. So here, we will do a wrap of text, i.e., extend the words of a cell in the same cell with the same column size and extend it through row size.

Using the Wrap Text Button in Excel, we can visualize cell values (text /alphanumeric/numbers) by multiple lines in the same cells.

Tips: For the next level of a higher range of work in AutoFit can be done using VBA CodingVBA CodingVBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task.read more, where without a selection of any cells, we can do this for the entire worksheet.

We can use the codes below by copy-paste in the VB Copy-paste In The VB In VBA, we use the copy method with range property to copy a value from one cell to another. To paste the value, we use the worksheet function paste exceptional or paste method.read more coding sheet.

Sub AutofitColumns() Dim wrksht As Worksheet For Each wrksht In Worksheets wrksht.Select Cells.EntireColumn.AutoFit Next wrksht</strong End Sub

This article is a guide to AutoFit in Excel. We discuss how to AutoFit in Excel using the top 5 methods with Drag, Select & Drag, using Double with examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –

  • Custom Number Format in ExcelSplit Cells in ExcelAutoFormat Excel