In the next article, we are going to show you how you can
change the width of a column and the height of a row in Excel.Excel is one of the tools most used by users of Windows environments to create their spreadsheets. It has a large number of functions and macros, which allow you to perform various tasks. It is very important to have this knowledge since you can not only modify the width and height of a column or row, you can also change the color of a cell, according to its text.
How to change the width of a column and the height of a row in Excel
We have already spoken on other occasions about the changes that Microsoft has implemented so that the user can make changes that were effectively impossible before. In this case, if we want to customize or change the width of a column and the height of a row in Excel so that the size of the data can match in the cells.
Excel, in this case, offers us a function called Auto-adjust so that in a very easy and simple way we can change these parameters. Of course, you have to learn how to use it in order to get the most out of it. Next, we are going to indicate to you, what steps you must follow so that you can execute this function as a true expert.
Step to change the width of a column and the height of a row in Excel
There are certain maximum and minimum characteristics that the columns and rows must have and this knowledge must be clear before making these adjustments. For example, the columns can have a maximum width of 255. Y represents the maximum number of characters that it can contain, with standard font size.
On the other hand, the rows can have a maximum height of 409, whereby default the height of a row is 15. When you add information in a standard column width and it exceeds this width. Excel allows data that does not fit in that column to move to other columns. For what later they are adjusted.
For it we are going to do the following, we select the Column, then we go to the Home tab then click on the Cells option. Then you must click on the Format option and in its options menu, we are going to select Cell size. Let’s observe that we have three different options to modify the width of the column.
The Column width option allows us to enter a number of the width of the column manually. But it is more difficult, than just dragging the column to the desired width, so in our case, it will not be useful. The second option is Auto-adjust column width, this is the option we are looking for.
With this option we can adjust the new size that the column should have, depending on the length of the content. And in this way, we have automatically changed the width of the column. Now to adjust the height of a row we must do the following, select the row with the Cut-off text option then you must click Format.
Then choose the Auto-fit row height option, this will allow Excel to adjust the height of the row to the text without any problem. In this way, you have learned in a very simple way, how to change the width of a column and the height of a row in Excel.