Excel Hack

Excel row height shortcut

Excel provides a handy shortcut key to adjust the row height. This allows you to freely change the row height using only the keyboard, without having to reach for the mouse. In addition to how to adjust the row height using the shortcut keys, this tutorial explains how to adjust the row height from the context menu, how to automatically adjust the row height, and how to adjust the height of multiple rows at once.

Row height shortcut

Display the Row Height dialog box

Windows
Access Key: Alt + H + O + H or Alt + O + R + E

Mac
None

AutoFit Row Hight

Windows
Access Key: Alt + H + O + A or Alt + O + R + A

Mac
None

Change the row height with shortcut keys

Explains how to change the row height using shortcut keys.

Total Time: 2 minutes

Select a cell

Select a cell

Select the cell in the row where you want to change the height. Press Alt + H + O + H or Alt + O + R + E.

Change the row height

Adjust the row height

The Row Height dialog box will appear. Enter the desired value, and press Enter.

The row height has been changed

The row height has been changed

Changed the height of the selected row.

Change the row height from the context menu

Select a cell

Select the cell in the row where you want to change the height.

Select a row

Press Shift + Space to select the entire row.

Press R

Press Shift + F10 to bring up the context menu.

Press R. This R refers to Row Height.

Adjust the row height

The Row Height dialog box will appear.

Enter the desired value, and press Enter.

The row height has been changed

Changed the height of the selected row.

AutoFit Row Hight

Select a cell

Select the cell in the row where you want to automatically adjust the height.

The row height has been automatically adjusted

Press Alt + H + O + A or Alt + O + R + A.

The row height has been automatically adjusted.

Changing the height of multiple rows

Select a cell

Select the cell in the row where you want to change the height.

Select a cell

Press Shift + (Down Arrow key) to select multiple cells.

Press Alt + H + O + H or Alt + O + R + E.

Adjust the row height

The Row Height dialog box will appear.

Enter the desired value, and press Enter.

I was able to change the height of multiple rows

I was able to change the height of multiple rows.