Excel AutoFit
Excel has a set row height and column width by default. The rows and columns in an Excel spreadsheet are all the same size. And anything that takes up more space than the current size of size spills out.
This Tutorial Covers:
- How to AutoFit Column Width in Excel?
- Basics of Excel Column Width
- Change the Column Width using Mouse
- Set the Column Width to a Certain Number
- Set the Column Width to Inches
- Excel AutoFit Column Width with Shortcut1.
- How to AutoFit Column Width in Excel?
Adjusting the width of a column in Excel is a common task. It is one of the regular tasks that you perform on a daily basis when creating reports, summary tables, or dashboards. You could indeed manually change their width by dragging the column header’s border. However, doing so on a regular basis can become time-consuming. Let’s take a look at how to automatically adjust column width/autofit in Excel.
- Basics of Excel Column Width
While you type something into an Excel cell, it will overflow if the text/data size exceeds the column size. AutoFit is an Excel feature that makes it possible to quickly adjust the row height or column width to completely fit the text.
In an Excel spreadsheet, you can specify a column width ranging from 0 to 255, with one unit equal to the width of one character displayed in a cell formatted with the standard font. The default width of all columns on a new worksheet is 8.43 characters, which corresponds to 64 pixels. Once a column width is set to zero (0), the column is hidden.
To see the current width of a column, click the right boundary of the column header, and Excel will show you the width:
Columns in Excel do not automatically resize as you enter data into them. If a cell’s value is too large to fit in the column, it extends over the column’s border and overlaps the next cell. A text string is cut off at the cell border, and a numerical value is overtaken with a sequence of hash symbols (######).
3. How to Change the Column Width using Mouse?
Let’s assume you have a data set like the one below, where the text pours into the other column as the column width decreases.
The following is how to use the mouse to autofit the column width:
Step 1: Move the mouse cursor to the right edge of the spine header. The cursor changes to an arrow icon on both sides.
Step 2: Drag the right border of the column header until the column is set to the desired width.
Result outlined below:
4. How to Set the Column Width to a Certain Number?
The Excel column width value represents the number of characters you can insert into a cell formatted with the standard font. To digitally resize the columns, perform the following steps:
Option 1:
Step 1: Select one or multiple columns for resizing. Ctrl + A or click the Select All button to select all columns. Here I have selected Column A.
Step 2: Go to the Home tab, within the Cells group, click Format > Column Width.
Step 3: In the Column Width box, enter the required number and click OK.
Result outlined below:
Option 2:
Step 1: Select one or multiple columns for resizing. Ctrl + A or click the Select All button to select all columns. Here I have selected Column A.
Step 2: Right-click on the selected column(s) and select Column Width from the contextual menu.
Step 3: In the Column Width box, enter the required number and click OK.
Result outlined below:
5. How to Set the Column Width with Inches?
You can specify the column width in inches, centimeters, or millimeters when preparing a worksheet for printing.
The following is the steps to autofit columns excel:
Step 1: Go to the View tab > Workbook Views group and click the Page Layout button to switch to the Page Layout view:
Step 2: Select one or multiple columns for resizing. Then drag the right border of the column header until the column is set to the desired width.
Excel will display the column width in inches as you drag the boundary.
Step 2: When the width is fixed, you may exit the Layout view by clicking the Normal button on the View tab in the Views group in the workbook.
Result are outlined below:
6. Excel AutoFit Column Width with Shortcut
There is a shortcut that you can use to automatically adjust the column widths in Excel so that everything adapts perfectly.
Below is the Excel autofit column width shortcut:
- To Autofit column width shortcut: Press ALT + H + O + I
- The alternative to ALT + H + O + I key is ALT + O + C + A.
- To Autofit row height shortcut: Press ALT + H + O + A
To use the autofit column width shortcut follow the below steps:
Step 1: Select the row/column that you want to autofit
Step 2: Then press Alt + H + O + I
Results are outlined below:
For AutoFit column width to the entire column, we should select the entire column and perform AutoFit task. If not, only selected cells will be set up automatically.
