When you create a new spreadsheet in Microsoft Excel, all of the rows and columns will be the same size by default.
But as you add data to your spreadsheet and make changes to its layout, it’s likely that you will wind up with columns of different sizes.
This can happen because Excel can expand its columns to fit the data within the cells in that column, which can naturally create columns of different sizes.
However, you have the ability to manually resize your columns, and you can even do it to multiple columns at once.
Our guide below will show you how to select multiple columns in Excel and make them the same size.
How to Make Multiple Columns the Same Size in Excel
The steps in this article were performed in the Microsoft Excel for Office 365 version of the application, but will work in other versions of Excel as well.
Step 1: Open your spreadsheet in Excel.
Step 2: Click on the letter above the first column to resize.
Step 3: Hold down the Ctrl key on your keyboard, then click the column letter for each additional column to resize.
Step 4: Right-click on one of the selected columns and choose the Column Width option.
Step 5: Enter the desired width into the field, then click OK.
Note that you can select all of the columns in a spreadsheet by clicking the gray button to the left of the column A heading and above the row 1 heading.
You can select multiple adjacent columns by clicking the leftmost column you want to select, then holding down the Shift key and clicking the rightmost column. This will select everything between the two columns you clicked.
Excel defines column width as a point value by default, but you can switch to inches by clicking the View tab, then selecting the Page Layout option.
- How to subtract in Excel
- How to sort by date in Excel
- How to center a worksheet in Excel
- How to select non-adjacent cells in Excel
- How to unhide a hidden workbook in Excel
- How to make Excel vertical text
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.