Comments on: How to AutoFit in Excel: adjust columns and rows to match data size

Microsoft Excel provides a handful of different ways to change column width and adjust row height. The easiest way to resize cells is to have Excel automatically determine how much to widen or narrow the column and to expand or collapse the row to match the data size. Continue reading

Comments page 2. Total comments: 36

  1. When I use row autofit in Excel I find that some fonts work well in the setting, but most fonts do not work. First, why do I see the discrepancy? Second, what are the best fonts you see that work well with the row autofit?

  2. Microsoft Excel provides a handful of different ways to change column width and adjust row height. The easiest way to resize cells is to have Excel automatically determine how much to widen or narrow the column and to expand or collapse the row to match the data size. This feature is known as Excel AutoFit and further on in this tutorial you will learn 3 different ways to use it

  3. Thank you so much. It was indeed helpful

  4. If only it worked for me. I still have random spaces at the bottom of some of the rows. Tried the method several times with increasingly increased widths, to the point of ludicrousness, but there were always some that ended up with those extra spaces.

  5. Svetlana,
    I have been around spread sheets since Lotus 123 days and have read and reviewed hundreds, if not thousands of suggestions on Google and Youtube "How To accomplish a task using a particular program". I have NEVER seen a better method of explanation than what you have displayed here. Congratulation: Keep up the GREAT work.

    1. Thank you so much, Jim! It's a real pleasure to hear praise from a professional.

  6. I witness how QuickBooks exports data to Excel and somehow executes an auto fit. Command. I often export data to an spreadsheet and then have to manually re size all columns. Is it possible to include nautofit command at the end of exports data that will execute and in turn automatically size the columns? Thanks

    1. Hello,
      Please try using a VBA macro. We are always ready to help you, but we do not cover the programming area (VBA-related questions).
      You may try to find the solution in VBA sections on mrexcel.com or excelforum.com.
      Sorry we can’t assist you better.

  7. i have to adjust entire sheet according to column A

  8. I have a query. I want to adjust data in one sheet to auto adjust value according to another sheet.
    Example:

    Sr. Code Value
    1. 1234 1212
    2. 4567 1814
    3. 7890 1314

    sheet 2
    Sr.Code Value
    1. 4567 1225
    2. 1234 1817
    3. 7890 1121
    as shown codes are same but may vary in rows. how to auto adjust the code different values to put automatically in front of their dedicated codes.

    Thanks in advance!

    1. Hi,
      Can u share the details with excel sheet.

  9. I am using Excel 2016, have a workbook with 12 sheet, each sheet has 50+ columns. I spend almost as much adjusting column width as I do entering data.

    I have seen a VBA written so that each time you "enter" data the column automatically adjust its width. Unfortunately, I cannot get it to work in my version or Excel, which is 2016.

    I am wondering if you have something that would work? I already have one VBA that will do this for each sheet in the work book, but in order to run it I have to select alt+F8 and then select run. This is almost as time consuming at doing it manually and isn't what I am looking for. I would like to be able to type data and the minute I push the enter key the column should automatically adjust to fit the data.

    Thanks,
    Mark

  10. Very nice and Excellent I admire your work and valuable knowledge you share.

    1. Thank you for your kind words, Mohammad! Our team will continue doing our best to bring the most interesting and useful features of Excel to our readers.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)