Currently your Excel works in Units, and now you need to convert the measurement system to Inches (In) and Centimeters (cm).
Go to View Tab
Under the Workbook Views section, click on Page Layout
Now your view has changed to something like this.
Select the column(s) or row(s) where you want to fix the width or height.
Enter the required value in this manner, for a 1 in X 1 in Cell box.
For centimeters, you can write “3 cm”.