Distribute Columns Evenly

Anonymous
2011-05-02T21:15:19+00:00

I cannot locate the feature "Distribute Columns Evenly" in Excel.  The help menu tells me to turn on the Tables toolbar but I don't see Tables listed under the Toolbars.  Please help...I know it's there...I just can't find it.

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
HansV 462.7K Reputation points MVP Volunteer Moderator
2011-05-02T22:14:06+00:00

That is a feature in Word but not in Excel, as far as I know.

You can set column width or autofit columns as follows:

Select the columns that you want to format.

Click Format on the Home tab of the ribbon, then Column Width... or AutoFit Column Width.

Was this answer helpful?

20+ people found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-12-07T15:43:10+00:00

    Here are step by step instructions that I found useful: https://answers.yahoo.com/question/index?qid=20060616160619AAuRSmK

    (For a 6-day week calendar, I input 26 for the width, and was great for my needs)

    Was this answer helpful?

    0 comments
  2. HansV 462.7K Reputation points MVP Volunteer Moderator
    2014-12-22T10:13:06+00:00

    No, nor in Excel 2013. You can use the methods described in my previous reply.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-12-22T04:25:01+00:00

    Hi,

    I am using EXCEL 2010,

    Is it now possible to

    distribute ROWS equally?

    Ravi Vare

    Was this answer helpful?

    0 comments