Hello friends.



I am adding content to a new Excel file. The data includes a small logo of a particular height. For each new row, I am manually increasing the height of each new row and I add data. So I am wondering if I can save time and simply select a number of rows and then increase the height of all the cells all at once.

Is there a way I can do this?

Cross post How do I quickly change the height of many rows at once? | Chandoo.org Excel Forums - Become Awesome in Excel
and
How do I set the height of rows quickly? | MrExcel Message Board

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

You can do this several ways:

Highlight a bunch of consecutive rows; then select the bottom border of the topmost row and drag it down manually. All the selected rows should resize to the same height.

Select any number of rows or cells (to select non-contiguous rows, hold down the Control key and cherry pick several cells), then go to the Format dropdown on your Home Ribbon, select Row Height, and input the numeric value you want for those row heights.

If you're doing that adjusting over and over again, you'll want to create a template for that type of spreadsheet that requires the logo, or record or write a macro with those steps. You can assign a button on your QAT to that macro and adjust new sheets with the push of that button.