Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to Change the Row Height or Column Width to Inches – Excelchat

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

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment


Subscribe to

Get updates on helpful Excel topics

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc