SOLVED

excel cell format size

Copper Contributor

I know how to resize a cell, but I want it to measure 1" x 4" and I can't figure out how to create a particular size in inches.  Any ideas?

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Elizabeth_Morrow 

Switch to Page Layout view on the View tab of the ribbon. You can then see the column width in inches by dragging the right edge of the column header:

S0696.png

In Page Layout view, you can also specify the column width in inches on the Home tab of the ribbon, in Format > Column Width...:

S0695.png

Similar for row height.

Thank you so much!
No problem with width, only the height of column and lettering
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@Elizabeth_Morrow 

Switch to Page Layout view on the View tab of the ribbon. You can then see the column width in inches by dragging the right edge of the column header:

S0696.png

In Page Layout view, you can also specify the column width in inches on the Home tab of the ribbon, in Format > Column Width...:

S0695.png

Similar for row height.

View solution in original post