Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to change column widths in Excel

How to change column widths in Excel

Transcript 

In this lesson, we'll look at several ways to set column widths in Excel.

You've probably noticed that columns in Excel do not expand to accommodate the data they contain. When the data in a cell is too wide to fit the column, it just overlaps the next column, or, it's clipped when the column to the right contains data. You can fix this problem by setting the column width.

Let's take a look.

All columns in Excel have a set width. To check the current width of a column, just click on the column divider to the right. You'll see the width displayed in characters.

You can set the width of a column by dragging the column divider to make the column wider or narrower.

It's also possible to set the column width numerically. With at least one cell selected in the column, click the Format button on the ribbon, choose Column Width from the menu, and type in a new width.

You can get to the same Column Width dialog box by selecting a column and right-clicking. Then, choose Column Width from the menu.

You can use these same techniques to set the column width for more than one column at a time.

Excel can also autofit columns so that they expand or shrink to fit the largest value. To use Autofit, just double-click the column divider to the right of the column you'd like to resize.

You can autofit columns by using the ribbon as well. Click the Format button and select Autofit Column Width from the menu.

Finally, you can autofit multiple columns at the same time using these same methods. First, select the columns you'd like to autofit. Then, apply Autofit using the Format button on the ribbon, or, by double-clicking a column divider in your selection.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Thank you, this is an excellent site to get an understanding of all the Excel formulas. Especially for brushing up or just rechecking the formulas.
Priti
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page