• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
How to Automatically Adjust Column Width in Excel

How to Automatically Adjust Column Width in Excel

November 18, 2021 by Madalina Dinita Leave a Comment

Suppose your Excel columns contain a lot of characters. In that case, you can manually adjust their width by dragging the border of the column header. But doing that constantly can become a time-consuming task. Let’s see how you can automatically adjust column width in Excel.

How to Make Excel Columns Expand to Fit Text Automatically

You can use the AutoFit feature to automatically adjust the column width in Excel.

  1. First, select the column for which you want to enable this feature.
  2. Then click on the Home tab.
  3. Click Format in the Cells group.
  4. Under Cell Size, select AutoFit Column Width.

AutoFit-Column-Width-excel

Excel will now automatically change the column width to accommodate text. There’s also a shortcut that you can use to get the job done. Simply select the column that you want to autofit, and then press the ALT, H, O, and I keys one after the other.

If you want to copy that width to another column, you can use the Paste Special option.

  1. Copy any cell from the column that has the right width. Simply select the cell and then use the Ctrl + C shortcut.
  2. Then right-click on a cell in the target column and select Paste Special.
  3. Make sure to check the Column widths option.Column-widths-paste-special-Excel
  4. Hit OK.

What If AutoFit Is Not Working?

If your column contains merged cells, you can’t use the AutoFit option. The same is valid if the Wrap Text option is selected. The only thing you can do is manually adjust the column width.

Conclusion

To automatically adjust column width in Excel, select your column, click on Format, and select the AutoFit Column Width option. Alternatively, you can also use the ALT, H, O, and I shortcut. Remember that the AutoFit option won’t work if your column contains merged cells or wrapped text.

Did you manage to adjust column width in Excel? Let us know in the comments below, and don’t forget to share this quick guide on social media as well.

You Might Also Like

  • How to Configure the Tab Width in Sublime Text 3
    How to Configure the Tab Width in Sublime Text 3
  • How to Add a New Column to TweetDeck
    How to Add a New Column to TweetDeck
  • Notepad++: How to Use "Column Mode"
    Notepad++: How to Use "Column Mode"
  • Kindle Fire: How to Adjust Volume
    Kindle Fire: How to Adjust Volume
  • Android 10: How to Adjust the Keyboard Size
    Android 10: How to Adjust the Keyboard Size
  • How to Adjust iPhone Home Button Settings
    How to Adjust iPhone Home Button Settings

Filed Under: Windows Tagged With: Excel

Reader Interactions

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • How to Print Labels from Excel Using MS Word Mail Merge
  • What Is NVMe Over TCP (NVMe/TCP)
  • Android Mobile Hotspot: How to Change the Password and Name
  • Windows 10: How to Force Quit and App
  • What is Dumpster Diving?
  • How to Download iOS 16 Beta 3 on iPhone or iPad
  • What is a Security Compromise?
  • Mastodon: How to DM Someone

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy