How do I change the default height of rows in Excel?

Question

I am changing the height of each row of an Excel file I am editing in order to accomodate picture data I am pasting into cells. But the method I am using is to manually expand the height of each row one at a time. I am sure there is a better and faster way, but I don't remember.

Answer 1

To increase the height of several consecutive rows, try selecting the first row (clicking the row number), then hold <Shift> and select the last row. Then change the size of any selected row using the mouse.

To modify separate rows, select the first row, then hold <Ctrl> and select the other rows. Then change the size of any selected row.

To set the height according to contents, select the rows, then double click the bottom margin of a row.

Answer 2

The most quick way is to select the rows that you want to change the height for.
Drag one of the rows to the height that fits your needs and release. All the rows that you had selected will be of the same height now.

Regards
John
CEO
https://mobilesinbd.com/