Tuesday, February 23, 2010

Adjust row height in Excel 2010

If your workbook contains text or other information that spans multiple lines then the necessity arises for the row height to get increased. There are many ways to adjust the row height. Take a look at them:
1. Manually adjusting the row height – To manually adjust the row height, place the mouse cursor at the intersection between the row headers and then drag to suit. For example, if you need to increase the height of row 2, place the mouse cursor between row 2 and 3. When you see the double headed arrow, keep the left mouse button in the pressed state and drag towards up or down.
2. Adjust to a specific setting – To adjust to a specific setting, right-click on the row header and click Row Height… to open the Row Height dialog box. Input a value for the row height and then click OK.
3. Automatically adjust the row height – There are two ways by which you can adjust the row height automatically.
a. Adjust the height based on the cell value that has the largest height value – Place the mouse cursor at the intersection between the row headers and then double click. This will automatically adjust the row height.
b. Adjust the height based on a particular cell height – Click on a cell and then from the Home tab, in the Cells section click Format and finally click Autofit Row Height.
/* */