How to Change the Row Height or Column Width to Inches

  • Post author:
  • Post category:Uncategorized

We can change the size of any cell in Excel using many methods. One of the most popular ways requires that we change the column width to inches or the row height to inches. In this tutorial, we will learn how to use this method to change selected cells to specific cell sizes in inches.

Figure 1 – Column width or row height in inches

Change Column Width or Row Height to Inches in Excel

  • We will go to File and then select Options

Figure 2 – Convert column width to inches

  • In the Options window, we will select the Advanced Tab

Figure 3- Pixels to inches

  • In the Advanced Tab, we will scroll to the Display section
  • In this section, we will go to Ruler Units and click on the dropdown menu
  • Here, we will select Inches as our preferred unit of Measurement

Figure 4 – Pixels to Inches

View Ruler to Change Row height or Column width in Inches

To see our conversions, we will have to enable the Ruler feature. To do this,

  • We will go to the View Tab and select the Page layout
  • Next, we will ensure that the Ruler button in the Show group  is marked

Figure 5 – Convert Excel Column width units

Resize Cell Row Height or Column Width to Inches

   1. To change Row Height to inches

  • We will select cells we wish to change
  • We will go to Home and select Format
  • Next, we will select Row Height

Figure 6- Row height units

  • In the Row Height dialog box, we will enter our desired figure.

Figure 7 – Convert Row height to inches

   2. To change Column width

  • We will select the cells we wish to change
  • We will go to Home and select Format
  • Next, we will select the Column Width
  • In the Column Width dialog box, we will enter our desired figure.

Figure 8 – Excel Column width units