What Are Three Ways to Change Column Width in Excel?

Microsoft Excel has a lot of different tools and settings, many of which allow you to perform the same action in multiple ways. One of the most common things to do in Excel is to change the size of cells, so it only makes sense that there is more than one way to accomplish this. If you are asking what are three ways to change column width in Excel, then our guide below can answer that question.

How to Change Column Width in Excel 2013

  1. Open your spreadsheet.
  2. Select the column.
  3. Right-click on the column and choose Column Width.
  4. Enter the new width, then click the OK button.

Our guide continues below with additional information to answer the question of what are three ways to change column width in Excel, including pictures of these steps.

The heights of rows and widths of columns in an Excel spreadsheet are the same size in every new spreadsheet that you create. But the data that you put into your cells can vary in size, and you may find that the default cell sizes are often too small or too large.

Fortunately, the sizes of your cells are elements that can be adjusted, and modifying your column widths is a simple task that will make your spreadsheet easier to read and work with.

So continue reading below to learn about several different methods that you can use to change the widths of your columns in Excel.

Did you know that there is also a method for how to expand rows in Excel? This can be useful when you have multiple lines of data inside of your cells and want it all to be visible.

How to Adjust Column Width in Excel 2013 (Guide with Pictures)

This article was written using Excel 2013, but the same steps can be applied in other versions of Excel as well. Additionally, you can follow similar steps if you need to adjust the height of your rows.

There are three different ways to adjust column widths that are discussed below. Choose the best option based on your spreadsheet needs.

Method 1 – Manually Resize Column Width

This option is best used if you wish to visually modify the width of your columns.

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Locate the column whose width you wish to adjust.

select the column to change

Step 3: Click the right border of the column letter, then drag it left or right to the desired width.

drag the column border to desired width

Method 2 – Numerically Resize Column Width

This option is best used if you want to make sure that all of your column widths are the same size. You can also use this option with multiple selected columns.

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Right-click the column letter that you want to change, then click the Column Width option.

what are three ways to change column width in Excel

Step 3: Enter a new value inside the Column Width field, then click the OK button.

enter value for column width

If you are not able to use right-click, then you can find the Column Width option by clicking the Home tab at the top of the window, clicking the Format button in the Cells section of the navigational ribbon, then clicking the Column Width option.

click format, then click column width

Method 3 – Resizing the Column Width Based on the Width of the Cell Contents

This option is best used when you simply want all of the data contained within a column to be visible.

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Click the column letter of the column whose width you want to adjust automatically.

select column letter

Step 3: Position your mouse cursor on the right border of the column, then double-click your mouse. The column will automatically adjust itself to fit the size of the data contained within it. This can make your column widths smaller or larger, depending upon your data.

double-click column border

Are there multiple columns in your spreadsheet that you would like to resize to fit their contents? Learn how to autofit column widths in Excel with just a few button clicks.

Additional Sources

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.