Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
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