I have a worksheet (Excel 2010) in which I want to delete 14 rows having different row heights, but after deleting I want to increase one row by the total height of the 14 deleted rows so that all my worksheets, when printed, will look alike, i.e. font size-wise. For example, if all my 14 rows have the same row height, it is easy for me to calculate the total height ( say 14 X 5 = 70) but my 14 rows have different heights. To find out each row's height and add it to get the total height of 14 rows is tedious. Is there a formula or a shortcut to achieve this? PLEASE HELP ME.

  • Would it be possible to use a different approach, like deleting the contents and leaving the original rows in place? (You could merge cells to simulate a single row if that is important.) – fixer1234 Nov 30 '14 at 18:28

If you can use VBA


Put this in some event of your sheet and it can be used to print or show in some cell, you can also automate the entire task if you want it to be performed repeatedly

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.