• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

AutoFit in Excel

April 27, 2021 by Andrew Childress
Autofit Excel

Excel columns are 65 pixels wide. But if you have a longer string of characters in a cell, they won’t fit. Here's how to use AutoFit in Excel

By default, Excel columns are 65 pixels wide. But if you have a longer string of characters in a cell, they won’t fit. Fortunately, this is easy to adjust with a feature called AutoFit. Let’s learn how to use AutoFit in Microsoft Excel.

How to AutoFit a Column in Excel

Imagine that you have a cell in Excel, and you type in the word Constantinople. You’ll notice that, when you use the default width of 65 pixels, the text spills into an adjacent cell. This can quickly get messy, and it’s hard to read.

Autofit Excel

This is where AutoFit in Excel comes in. Think of a column with multiple lengthy character strings in its cells. AutoFit automatically judges the longest cell in a column, and then adjusts the column width to fit it, and therefore all other cells.

To use AutoFit, click on the column header to select the entire column. In this example, that’s the B just above column B.

Then, with the full column selected, go to the Home tab on Excel’s ribbon. Find the Format dropdown, and from it, click on AutoFit Column Width.

Autofit in Excel

Excel will automatically adjust the width of your column to fully encompass the longest character string found within that column. This helps ensure that all of your content will be readable.

Autofit Excel columns

How to AutoFit Multiple Columns in Excel

Imagine now that you have multiple columns that you want to AutoFit. There’s no reason to adjust them one by one.

Begin by selecting the first column in the series. Then, hold down Shift on your keyboard, and click on the column header for the last (rightmost) column that you want to AutoFit. Watch as Excel selects the full range of columns.

How to autofit in Excel

Finally, repeat the AutoFit process, and all of the selected columns will update at once. As you can see, Excel makes it easy to update columns with AutoFit.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Compare two columns in ExcelCompare Two Columns in Excel
Next Post:Round Down in ExcelRound down in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top