How to Change the Width of a Column and the Height of a row in Excel


Another of the wonderful tools that we can use from the Office suite of Microsoft, is the excel spreadsheet. Through it, we can perform graphics, statistical calculations, our accounting work, in short a number of operations. But sometimes something so simple how to change the width of a column and the height of a row in Excel, it can complicate your life and here we will tell you what you should do.

When we are working on a spreadsheet and we need to empty information, we use the different cells for it. And we have always thought that these must be static, that is, always with the same dimensions.

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.

You may also be interested in:

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 various tasks to be carried out. 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 previously impossible. 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 row width

Excel In this case, it 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 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 must have columns and rows and we must be clear about this knowledge 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 a standard font size.

On the other hand, the rows can have a maximum height of 409, where by 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, go to other columns. For what later they are adjusted.

For it we are going to do the following, 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 width you want, 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.

excel column document

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 changed automatically 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.

How useful did you find this content?

Click on a star to rate!

Average score 0 / 5. Counting of votes: 0

So far, no votes. Be the first to rate this content.

I'm sorry this content was not useful for you!

Let me improve this content!

Tell me, how can I improve this content?

You may also be interested in:

Deja un comentario