How can automatically match (AUTOFIT) column width (width) and height of rows (height) in MS Office Excel

Although Microsoft Office Excel is used in very large scale, many of those who do not know than it uses basic functions thereof. Among those who Excel users not very advanced and who daily lose precious time manual adjusting different files created with this software, we hope we can work easier making them aware with function AutoFit.

What should we know about AutoFit function in Excel

Whenever we created tables Excel, depending on the data you enter in their cells need to adjust width and height for their information to be visible and easily understood by those who requested (or those who are "for": D), these tables. Generally adjustment tables "papa" more time than "filling" their information. The simplest way to avoid this and to save time (and nerves) is using AutoFit function (Which - unfortunately - a very large proportion of Excel not heard). This function (as you can easily tell) automatically change row heights and column widths in MS Excel so achieving developed tables or files will no longer be a chore for those who find AutoFit before losing several minutes just to adjust them.

Before using AutoFit function should however keep in mind a few important things:

  • There are limits to how large or small can make the columns and rows of Office Excel. Limit width of a column is 225 characters (to 8.43 as is the default value) and limit the height of a row is 545 pixels (Compared to 20 pixels).
  • the modification font, The size thereof, or the use of features such as bold or italic decreases the number of characters that can enter into a cell
  • width columns value equal to 0 are not displayed in Excel spreadsheet. The same is true for rows with height = 0 value (equivalent to using function Hide)

How can we access AutoFit function in MS Excel

When placing a cell allows more characters than the default value of a column, Excel allows expansion of data entered in the adjacent columns (Immediately following that in which they were introduced).

test tanks

To avoid this we have to adjust the width of the cell so that the entire information to be contained by a single cell. Of course, the adjustment may do it manually, but if that is necessary to create a table that should be introduced in various other information - obviously on different occasions - adjusting individual cells becomes irritating.

To automatically adjust the width of a column will first need to select the cell containing the information by which we want to adjust the length of that column,


Then in the top of the Excel sheet click on the tab Home> Format and select AutoFit Column Width. The column will be immediately adjusted depending on how many characters contain information typed into your cell.

New width

If later you decide for whatever reason to return to the default value of the column, Go all in Format and click on Column WidthThen enter the default value (8.43) and click OK (option Default Width no change in the default column width, but change the default value of the width of a column (Eg, change the default value of a column of 8.43 in any other value, such as 43.8 etc.).

Given that Excel automatically change the height of a row of cells depending on the font sizefunction AutoFit Row Height It is not of major importance as AutoFit Column Width.


But in some cases - as happens sometimes when dam copy / paste a written information with a larger font than the default - the adjustment is not automatic and it is necessary to use function AutoFit to change the height of the row.


Note: Although Excel may seem too rigid or boring in some cases it is well to remember that it has some very interesting features that can make using this software in a simple activity and fluency.

How can automatically match (AUTOFIT) column width (width) and height of rows (height) in MS Office Excel

About the author


Passionate about everything that means gadget and IT, I am pleased to write on from 2006 and I love to discover new things about computers and macOS, Linux operating systems, Windows, iOS and Android.

Leave a Comment