Excel: Quickly resizing a number of rows


In Excel (this was done in Excel 2010, but the version shouldn’t matter), you can quickly resize a number of rows to be the same height using this quick trick.

  1. Highlight the rows you want to resize by clicking the row marker for the first row, hold SHIFT and drag your mouse down.
  2. Resize any of the rows within the selection by clicking between the row markers and dragging up or down

Animated GIF of resizing rows in Excel