Copy and Paste Row Size
Currently, there's the option to copy the size of a column and paste the width of that column to other columns in a sheet. However, there is no such option if you wanted to copy and paste the height of a row. This would be very valuable. Thanks!
Yeah, see that's my problem. If I autofit contents, some of the content is different sizes, therefore all the rows are different heights. I need all my charts to have the same format not only for general readability, but also so that I know they will always line up row to row and scale the same way on the page when I print.
I totally agree with Anonymous "It will be very valuable indeed especially when comparing 2 sheets together (view side by side)"
It will be very valuable indeed especially when comparing 2 sheets together (view side by side)
Victor Chen commented
I agree. Sometimes I want to do paste special for the row height.
Never in Excel
Why column and not row
Ryan MacGregor commented
This has always been a curious omission for me.
Kenneth Barber commented
I guess you can always AutoFit after pasting. However, that doesn't work if you need to preserve a height other than what AutoFit would give you.