How to Add Space Between Columns in Excel: A Step-by-Step Guide

Adding space between columns in Excel can be accomplished by adjusting the column width. Simply place your cursor on the line between two column headers, click and drag to the desired width, and release the mouse button. This creates a gap between the columns, making your data easier to read and more visually appealing.

After you complete this action, your Excel worksheet will have a cleaner, more organized appearance. The data in each column will be more distinguishable, and the overall look of your spreadsheet will be improved.


When working with Excel, one of the key aspects of creating a readable and professional-looking spreadsheet is the organization of data. While Excel does a great job of keeping everything in neat rows and columns, sometimes the default settings just don’t cut it. That’s where adjusting column spacing comes in handy.

Whether you’re a financial analyst crunching numbers, a marketer organizing campaign data, or a student putting together a project, having the ability to customize the spacing between columns can make a world of difference. It not only enhances the visual appeal of your spreadsheet but also makes it easier to navigate and interpret data. Let’s dive into how you can add that much-needed breathing room between your columns.

Step by Step Tutorial

Before we get into the nitty-gritty, let’s understand what these steps will achieve. By following this tutorial, you’ll learn how to manually adjust the space between columns in Excel, giving your data more room and making it more legible.

Step 1: Select the Column

Click on the right boundary of the column header you wish to adjust.

When you hover over the boundary, your cursor will change to a double-sided arrow, indicating that you can click and drag to adjust the width.

Step 2: Adjust the Width

Click and drag the boundary to your desired width.

As you drag, a tooltip will appear, showing the current width of the column in pixels. If you’re aiming for consistency across multiple columns, keep an eye on this number.

Step 3: Release the Mouse Button

Let go of the mouse button to set the new width of the column.

After releasing the button, the column will now be set to the new width, and you’ll see the space between the columns has increased accordingly.


Enhanced ReadabilityAdding space between columns can make the data in your Excel spreadsheet easier to read.
Improved AestheticsSpacing out columns can make your spreadsheet look more professional and visually appealing.
Better Data InterpretationWith clearer separation, it becomes easier to analyze and interpret the data presented.


Potential Data MisalignmentIf not done carefully, adjusting column widths can lead to misalignment of data across rows.
Reduced Space for DataBy increasing the space between columns, you may reduce the available space for your actual data.
InconsistencyManually adjusting column widths can lead to inconsistency, especially if you’re trying to match the widths across multiple sheets or workbooks.

Additional Information

Now that you know how to add space between columns in Excel, here are a few extra tips to keep in mind. Firstly, if you’re looking to adjust multiple columns at once, you can select multiple columns by clicking and dragging across the column headers before adjusting the width.

Also, if you’re aiming for precision, you can right-click on the column header and choose ‘Column Width’ to enter a specific numerical value. Remember, the default unit of measurement in Excel is characters, but you can input a value in pixels as well. Lastly, for those who love shortcuts, you can use ‘Alt’ + ‘H’ then ‘O’ and ‘W’ to quickly adjust column width without using the mouse.


  1. Select the column by clicking on its right boundary.
  2. Adjust the width by clicking and dragging.
  3. Release the mouse button to set the new width.

Frequently Asked Questions

Can I adjust multiple columns at the same time?

Yes, you can select multiple columns by clicking and dragging across the column headers and then adjust their width simultaneously.

Is there a way to set a specific width for a column?

You can right-click on the column header, choose ‘Column Width’, and enter the exact width you desire.

What is the default unit of measurement for column width in Excel?

The default unit is characters, but you can also enter values in pixels.

Are there any keyboard shortcuts to adjust column width in Excel?

Yes, you can use ‘Alt’ + ‘H’ followed by ‘O’ and ‘W’ to open the column width dialog box without using the mouse.

Will adjusting column widths affect the data in my cells?

Adjusting column widths will not alter the actual data, but it may affect the way data is displayed if the width is too narrow for the content.


In conclusion, knowing how to add space between columns in Excel is a simple yet powerful skill that can enhance the clarity and visual appeal of your spreadsheets. With just a few clicks, you can transform a cluttered and overwhelming dataset into a clean, easy-to-read table that not only looks professional but also aids in data analysis.

Remember, while it’s important to have visually appealing data, it’s equally crucial to maintain the integrity and legibility of the information presented. So, go ahead and give your Excel worksheets the breathing room they deserve, and watch your data come to life!

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy