Page Layout Column Width

[Yazilliclick]

Hi All,

I'm working on an excel sheet in Office 2007. I've changed my ruler units to mm and gone to the page layout view and want to change my columns to specific widths in mm. It does come up with the width in mm and let me change it however when going back it's adjusted to a slightly different value, for example changing my column width to 15mm it reverts to 14.82mm.

Is there any way to make this absolutely exact?

Thanks a bunch!

 

[Bill_Biggs]

Columns widths are based on Pixels. Here is the conversion that you will find in help under "Measurement units and rulers in Excel"

Excel Workbook
	A	B	C
1	Points	Pixels	Inches
2	18	24	0.25
3	36	48	0.5
4	72	96	1
5	108	144	1.5
6	144	192	2
Sheet1

So covert your mm to inches and select the closest number of pixels to the measurement you need.

 

[Yazilliclick]

So even on the page layout screen where I am supposedly setting the width in mm ( column width comes up in mm), it's actually rounding that to the nearest pixel value?

 

[Bill_Biggs]

Yes. By the way, welcome to the board!

 

[Yazilliclick]

Well that's annoying and slightly deceiving

Thanks for the welcome though :D