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

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Change Column Width in Excel

August 27, 2021 by Andrew Childress
Change column width Excel

Spreadsheets take all sizes and forms, no matter what type of data. Let's learn how to change column width in Microsoft Excel.

Spreadsheets take all sizes and forms. No matter what type of data you show, you’re likely going to spend some time adjusting the format and style of your spreadsheet so that it’s easy to read.

That includes resizing your spreadsheet’s columns. Let’s learn how to change column width in Excel.

How to Change Column Width in Excel

Columns run vertically on the grid in Excel and are marked with letters above them. In Excel, you can easily change the column width with just a couple of clicks.

Place your mouse cursor on the small line between two columns until your mouse changes to a double arrow. Then, click and drag the column size to the desired width. Then, release the mouse button, and the column is resized.

Change column width Excel

Notice that you’ll also see a pixel width as you drag the column. You can also double click on the line between columns to automatically resize the column to match what’s inside of it. This is the quickest way to make your column width fit the content inside of it.

How to Change Multiple Column Widths in Excel

Let’s say that you have several columns that need resizing. Instead of adjusting each column one at a time and guessing at making them the same width, you can resize them all at the same time. Best of all, the width will match exactly for each column.

To resize multiple column widths, start by selecting a few columns. In my example, I’ll click and drag over columns F through H in the spreadsheet. Then, click and drag one of the columns to the desired size.

Multiple column widths Excel

That’s it! You’ll instantly see that all three columns are resized and match the same width. That keeps your spreadsheet neat and tidy and saves you the work of resizing them individually.

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

About Andrew Childress

Previous Post: « Create from file audio Add Audio in Excel
Next Post: Add Icon Sets in Excel Add icon sets in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT 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
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top