How To Make Excel Cells Expand To Fit Text Automatically

In this article i will show you how to make excel cell expand it’s width and height to fit the input text width or height automatically.

1. Make Excel Cell Expand To Fit Text Size Method 1.

  1. Put the mouse pointer at the cell’s column heading right border or row heading lower border that you want to expand.
  2. When the mouse pointer change to a left-right or up-down arrow, double click it.
  3. Then you can find the cell has been expanded to fit the text size.
    autofit-excel-double-click

2. Make Excel Cell Expand To Fit Text Size Method 2.

  1. Select the excel cell that you want to expand to fit the text size.
  2. Click Home —> Format —> AutoFit Row Height / AutoFit Column Width menu item to expand it.
  3. Above menu item has shorcut key that is Alt + H( Home tab) + O ( Format menu ) + A ( AutoFit Row Height ) / I (AutoFit Column Width)
    autofit-excel-ribbon

3. Expand Multiple Excel Cell To Fit Text.

Some times you need to expand multiple excel cells to make them fit the text content, you can follow below steps to do it.

  1. Select multiple columns or rows.
  2. Or press Ctrl + A to select the whole excel worksheet.
  3. Then you can follow method 1 or 2 to expand all the columns or rows.

Leave a Comment

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.