General discussion

Locked

0.5" Fixed Column width

By adrice ·
In Excel, how do you set a column width to precisely 0.5" - rather than use a figure that represents the number of characters that can be displayed in a cell formatted with the standard font.

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

0.5" Fixed Column width

by "JB" In reply to 0.5" Fixed Column width

Go to Format then column and click on width then type in the size you want it. I just tried it and it worked fine.

Collapse -

0.5" Fixed Column width

by adrice In reply to 0.5" Fixed Column width

Did you measure the resulting width?

I'm sorry, but your suggestion simply resizes the column width to 1/2 (0.5)the width of a normal font, which is NOT 0.5" (inches).

I think the solution will be a bit more complex than you realize, but thanks anyway! :)

p.s. [right-click] on Column bar and pick] "Column Width..." is quicker, in your case.

Collapse -

0.5" Fixed Column width

by James_Randy In reply to 0.5" Fixed Column width

Since no one cared enough about this question to answer it, just close the question and give me the points.

Collapse -

0.5" Fixed Column width

by adrice In reply to 0.5" Fixed Column width

The question was auto-closed by TechRepublic

Collapse -

0.5" Fixed Column width

by tjc In reply to 0.5" Fixed Column width

figure out what font and font size you want and then use the method above but make it the equivelent size for .5" on the screen and then print and see, then adjust the size according on the screen till the print out is the .5" that you want.

Collapse -

0.5" Fixed Column width

by adrice In reply to 0.5" Fixed Column width

The question was auto-closed by TechRepublic

Collapse -

0.5" Fixed Column width

by Cedric King In reply to 0.5" Fixed Column width

I would second the answer above that you do a print out and from that print out, adjust the column width on screen from there.

Collapse -

0.5" Fixed Column width

by adrice In reply to 0.5" Fixed Column width

The question was auto-closed by TechRepublic

Collapse -

0.5" Fixed Column width

by adrice In reply to 0.5" Fixed Column width

This question was auto closed due to inactivity

Back to Windows Forum
9 total posts (Page 1 of 1)  

Operating Systems Forums