How to Make Columns the Same Size in Excel for Office 365: A Step-by-Step Guide


Michael Collins

Making columns the same size in Excel for Office 365 is a simple task that can be accomplished in just a few clicks. You’ll need to select the columns you want to resize, right-click, and choose ‘Column Width’. From there, enter the desired width and voila! All selected columns will now be the same size.

Step by Step Tutorial: How to Make Columns the Same Size in Excel for Office 365

Before we dive into the steps, let’s understand what we are trying to achieve here. Excel for Office 365 allows you to resize your columns to make your data look neat and organized. By following these steps, you can ensure all your selected columns will be uniform in size.

Step 1: Select the Columns

Click on the header of the first column you wish to resize, then hold down the ‘Shift’ key and click on the header of the last column.

Selecting multiple columns at once is a time-saver. Make sure you click on the actual column headers (the letters at the top of the spreadsheet), not the cells within the columns.

Step 2: Right-Click on Column Headers

After selecting the columns, right-click on any of the column headers you have highlighted.

Right-clicking opens up a context menu that provides several options for column manipulation – including the ‘Column Width’ option.

Step 3: Choose ‘Column Width’

In the context menu that appears after right-clicking, find and select ‘Column Width’.

This option allows you to set a specific width for all selected columns. It’s important to note that the width is measured in characters, so a width of 10 means that 10 characters can fit side by side in the column.

Step 4: Enter Desired Width and Click ‘OK’

In the ‘Column Width’ dialog box, enter the width size you want for the selected columns and then click ‘OK’.

The number you enter will determine the width of the columns. Consider the type of data you have when deciding on the width to ensure all data is visible and the columns are not too wide or narrow.

After completing these steps, all the columns you selected will now be the same size. This uniformity makes data more readable and organized, and it’s especially useful when you’re working with large spreadsheets.

Tips: Making Columns the Same Size in Excel for Office 365

  • To quickly select all columns in your sheet, click on the triangle icon at the intersection of row numbers and column headers.
  • Double-clicking between column headers can auto-resize columns based on the longest piece of data in each column.
  • You can use the ‘Format Painter’ tool to copy the width of one column to another.
  • Keyboard shortcut lovers can use ‘Alt + O + C + W’ to open the ‘Column Width’ dialog box quickly.
  • Remember that you can always undo your changes by pressing ‘Ctrl + Z’ if the new column width doesn’t look right.

Frequently Asked Questions

Can I make columns the same size using keyboard shortcuts?

Yes, you can use ‘Alt + O + C + W’ to open the ‘Column Width’ dialog box without using the mouse.

Will resizing columns affect the data in my cells?

No, resizing columns only changes how the data is displayed, not the data itself.

Can I make non-adjacent columns the same size?

Yes, by holding the ‘Ctrl’ key while selecting columns, you can select non-adjacent columns and then resize them simultaneously.

Is there a limit to how wide I can make a column?

Excel columns can be up to 255 characters wide.

What is the default column width in Excel for Office 365?

The default column width is 8.43, which means it can display 8 characters of the default font size.


  1. Select the Columns
  2. Right-Click on Column Headers
  3. Choose ‘Column Width’
  4. Enter Desired Width and Click ‘OK’


So, there you have it! Making columns the same size in Excel for Office 365 is a piece of cake once you know what to do. Remember, the key to mastering any software, including Excel, is to get hands-on and experiment with different features. Don’t be afraid to try resizing your columns in different ways to see what works best for your data. And always keep in mind that if you make a mistake, the trusty ‘Ctrl + Z’ is there to save the day. Whether you’re a student, a professional, or someone who loves organizing data, knowing how to make columns the same size in Excel is a useful skill to have. So go on, give it a try, and watch your spreadsheets transform into organized, easy-to-read tables that will impress anyone who sees them!