![spreadsheet converter row heigth spreadsheet converter row heigth](https://slidetodoc.com/presentation_image_h/9dba77f1e73846aa302fd61c62851410/image-29.jpg)
Suppose you have the data set below and you want to autofit the row height – which is to increase it just enough to accommodate text in all rows.īelow are the steps to auto-fit row height with a simple double click: But if there are hundreds, you can use the two methods shown in this section. One of the major reason you may want to resize the row height is when you have more text in the cell (which is on the second or third line in the same cell) and it’s not visible.īy increasing the row height, you will make the entire text visible.īut how do you know how much to increase the row size? If there only a couple of rows, you can consider doing this manually. when you select multiple rows, no matter what their current height is, they all will have the same height once you’re done. In this example, I have selected just one row, but you can also do the same with multiple rows. Leave the button when you have achieved the required height.Hold the left mouse button and drag it down.
![spreadsheet converter row heigth spreadsheet converter row heigth](https://cdn.extendoffice.com/images/stories/doc-excel/change-cell-size/doc-change-cell-size-1.png)
![spreadsheet converter row heigth spreadsheet converter row heigth](https://slidetodoc.com/presentation_image_h/9dba77f1e73846aa302fd61c62851410/image-22.jpg)
Suppose you have a data set as shown below and you want to increase the height of the second row. If you want to change the height of one row or a few adjacent rows, this is a quick way of doing this.