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