Column width Units

G

Guest

Guest
I have foolishly created a design were my column wdths are in MM, i need to input these precise measurements into my spreadsheet, however i can't work out what measurement the columns are measure in, and how i can convert it into mm, please help, probably very easy but very frustrating!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Hi there
According to Help, the display column width is the average number of digits 0 through 9 of the standard font that fits in the cell.
This probably isn't very helpful, but presumably your project is eventually to produce this on a printed page of some sort. If so, print out a few pages of grid pattern and measure the column / row widths and adjust them till they match the scale of your drawing.
Hope this is of some use
Derek
 
Upvote 0
G'Day Derek,

I made a 118mmx118mm black square in paintbrush, saved it as a bitmap and then stuck it in excel. Then I increased the column width which it sat on so it straddled the image then looked at the column width which was 53.43 units

so 53.43 excel column width units = 118 mm

or 259/572

maybe you can adjust you measurements by that same proportion and in theory it should all work out

Hope this helps, albeit relatively negatively

Chris
:)
This message was edited by Chris Davison on 2002-02-21 12:14
This message was edited by Chris Davison on 2002-02-21 12:16
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,025
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top