row height & col width in inches

**hxly2** · 01-11-2007, 08:10 PM

I want to change the height and width of cells using INCHES, and some versions of excel do allow inches, but other versions use # of characters. How do I switch from # of characters to inches, for specifying row height and column width? Thanks.

**Bryan Hessey** · 01-12-2007, 03:05 AM

Originally Posted by hxly2

I want to change the height and width of cells using INCHES, and some versions of excel do allow inches, but other versions use # of characters. How do I switch from # of characters to inches, for specifying row height and column width? Thanks.

Hi,

I doubt that you can, but see http://office.microsoft.com/en-us/ex...517241033.aspx

hth
---

**hxly2** · 01-12-2007, 05:17 PM

Originally Posted by Bryan Hessey

Hi,

I doubt that you can, but see http://office.microsoft.com/en-us/ex...517241033.aspx

hth
---

That's odd because I have a mac version of excel that does use inches! I just need to do it on a pc. Go figure

**Bryan Hessey** · 01-13-2007, 05:16 AM

Originally Posted by hxly2

That's odd because I have a mac version of excel that does use inches! I just need to do it on a pc. Go figure

I would not be able to figure why anyone would use a mac setting on a windows pc, but from memory Excel on Windows has not used Inches for row height since Excel '97.

---

**ericbrunelle** · 07-20-2010, 06:40 PM

Excel 2007 will display column width or row height in inches if you go to View > Workbook Views > Page Layout.

**martindwilson** · 07-20-2010, 07:26 PM

macs use inches coz it's out of step with the rest of the world

**nonnifrog** · 02-17-2011, 08:37 AM

I highlighted the rows and columns that I want to use. For instance, I wanted a layout of 24 x 36 cells, each with a column width and row height of 0.25" to represent a 24" x 36" canvas. I selected 'Page Layout' . While still in Page Layout I clicked on the HOME tab. I right-clicked in the selected area, went to format cells, and used inches. I could not get this drop down menu unless I transferred to the HOME tab.