Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Auto Expand Multiple Columns in Excel

December 16, 2015 by Tyrone Pernsley

One of the most common fears of Excel is getting unruly data files and not knowing how to quickly and easily format it to look nice. Here we will go over when and how to auto expand multiple columns in Excel.

Do you ever get a dump of Excel data where the content in cells runs over cell margins making the data unreadable? I’ve seen many files that come out looking like this one below:

If you’re anything like me, looking at this is frustrating because it should be in nice neat columns where each cell is expanded to the exact length needed to be able to clearly see the data in the cell.

You can follow our tips on manually expanding columns and go through each one, manually adjusting. This can take some time though (especially when dealing with data files with more than our 5 column headings in our convenient example above). Could you imagine doing that with say, 20 column headings? You might also not get it exactly right the first time either and have to adjust it multiple times until it looks right.

So, don’t waste your time with that when you need to auto expand multiple columns in Excel.

To follow the process in the image above, simply highlight all of the columns, making sure to highlight from the letters above Row 1 so that the whole column gets highlighted. Once this is done, hover your cursor on anyone of the dividing lines between the lettered heading for the column so that is looks like:

Then double click and boom! – all of your columns automatically adjust to the proper width to display the data in the cells below.

That’s it and you’re done! So, don’t fear those ugly looking data dump nor concern yourself with data running over the preset column with when doing data entry. You know have the tools to quickly and easily auto expand multiple columns in Excel.

We hope you found todays quick and easy Excel lesson beneficial. Don’t forget to follow ups on Social Media and subscribe to the blog to get convenient, quick tips like this, and other great Excel training tips so that you can take the fear out of Excel.

Comments

  1. Lygia McMillan says

    February 2, 2016 at 10:40 am

    Awesome Tip!!! I have spent so much time re-spacing this is extremely useful!

    • Kevin Erdman says

      February 3, 2016 at 8:51 am

      Glad you found the tip useful! I hope we can help you with any other Excel questions you might have.

  2. Pat says

    February 11, 2016 at 6:01 am

    This doesn’t seem to work in 2016 excel any thoughts?

    • Kevin Erdman says

      February 11, 2016 at 4:56 pm

      Hi Pat,

      That’s interesting because it should work in 2016. If you are trying to get the columns to autofit the cell values, one thing you can do is:

      Go to Home –> Cells Group –> Format on the home Ribbon. Then under Cell Size, click “AutoFit Column Width”

      This should have roughly the same effect, but the tip in this article should apply to 2016 as well. I am not sure why it isn’t working for you. I will look into this further for you.

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In