Now you can right click the gray numbers to the left of any row, and select Delete. This will fix the calculation at the bottom of the column in place. Select View from the menu, and then select Split from the Windows group in the ribbon. To do this, place the cursor on the calculation you want to fix in place. The trick to fix the calculation row or column in place is to use the Excel Split feature. This is because the freeze feature only freezes rows above or to the right of the cursor.
![excel formula for row height excel formula for row height](https://i.ytimg.com/vi/qwxN4rqvjgs/maxresdefault.jpg)
If you try to use the freeze option to fix that bottom or right cell, it won’t work.
![excel formula for row height excel formula for row height](https://cdn.extendoffice.com/images/stories/doc-excel/doc-copy-with-row-height-column-width/doc-copy-with-row-height-column-width8.png)
And since calculations are usually at the very bottom or the right of a sheet, the result is usually not listed on the sheet when you’re trying to delete or add a row. In a large sheet like this, it can be difficult to add or delete a row and see the result of a calculation update at the bottom of a column or end of a row. The “freezing” feature in Excel is very useful, especially for very large sheets where you need to scroll so far to the right or down that the label row or column gets shifted off of the sheet.įreezing any row or column fixes it in place so you can see it no matter where else you move the cursor in the spreadsheet. There are two ways of auto-adjusting the row height in Excel. As discussed earlier, this utility is based on the size of text present in a particular row.
#Excel formula for row height how to#
Freeze First Column: Only fix the left row of the sheet in place. We will now see how to use Excel’s AutoFit Row Height utility to fit the row height to the best fit automatically.Freeze Top Row: Only fix the top row of the sheet in place.If you wanted to only freeze the rows above or the columns to the left, you could use one of the other options.