Click-and-dragging and AutoFitting are the easiest ways to change row and column dimensions. But in some cases, you want to control the exact height or width.
There’s an easy way to do that, too.
First, click into any cell in the row or column you’d like to resize.
Then, in the Home tab of the Ribbon, click Format (you’ll find it in the Cells section):
In the dropdown, you’ll see Row Height, AutoFit Row Height, Column Width, and AutoFit Column Width.
If you select Row Height or Column Width, you’ll get a dialog box that lets you enter the width in centimeters.