How to change cell size to inches/cm/mm/pixels in Excel?


By rule units, you can set the cell sizes to inches, cm, mm, and pixels. In this tutorial, we will take an example and show how you can do it in a step-by-step process.

Step 1

Open a Microsoft Excel Sheet, once the excel sheet gets open go to File or Office Button and then select Option and in Options go to Advanced option as shown in the below screenshot for your reference.

Step 2

Now you need to scroll down towards till you see the option called Display section. In there you will see a Ruler Unites, click on it and select the nit which you want to set it to the cell in Excel as shown in the below screenshot for your reference.

Step 3

Now you need to click on OK. Now you need to click on the page Layout and then click on view as shown in the below screenshot for your reference.

Step 4

Go to Home and then select > Cells > Format as shown in the below screenshot for your reference.

Step 5

Once you click on the format you will see the list of options in which you will see the options row height and column width. Click on row height and resize the cell, click OK as shown in the below screenshot for your reference.

Step 6

Now click on column width and resize the width of the cell, click OK as shown in the below screenshot for your reference.

Step 7

Once you resize the column width and row height to 4. You will see the result as below screenshot.

Conclusion

In this tutorial, we explained how you can change cell size to inches/mm/pixels in Excel.

Updated on: 06-Feb-2023

3K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements