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.
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.
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.