How to Make All of the Columns the Same Size in Microsoft Excel

Written by danielle cort
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make All of the Columns the Same Size in Microsoft Excel
Excel offers two ways to resize columns. (Erik Snyder/Lifesize/Getty Images)

If the information in each of your columns is more or less of the same length, you can choose to make every column the same width. Evenly-sized columns may look better than unevenly-sized columns, especially when you print your spreadsheet. Resize the columns using the mouse if you want to size the columns by eye and do not need precise measurements. Resize the columns using the menu if you want columns to have a specific width.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

    Using a Mouse

  1. 1

    Open the Excel worksheet with data in columns.

  2. 2

    Hover your cursor over the letter of the first column you wish to select. When the black down arrow appears, click and drag across to the last column you want to select.

  3. 3

    Hover on the line between any two selected column letters--it doesn't matter which two--until you see a black symbol with two arrows pointing in opposite directions. Click and drag left to make the columns narrower or drag right to make them wider. All the selected columns should now be of equal width.

    Using the Menu

  1. 1

    Open the Excel worksheet with data in columns.

  2. 2

    Hover your cursor over the letter of the first column you wish to select. When the black down arrow appears, click and drag across to the last column you want to select.

  3. 3

    Click the "Home" tab, then click "Format" in the Cells section.

  4. 4

    Select "Column Width" from the menu.

  5. 5

    Enter a number in the box provided and click "OK." You can specify any number between 0 and 255; this represents the number of characters the column will display.

Tips and warnings

  • If you enter "0" for column width, your column will be hidden.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.