WIDTH OF COLUMN

Q

qwerty

Is there any way to change the width of columns and row from pixels to
centimetres??????

REgards in advance
 
G

Gord Dibben

Row heights are measured in points or pixels. There are 72 points to an inch
and "maybe" 96 pixels to the inch.

The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font that fit in a cell.

For an interesting and enlightening discussion on this subject see

http://snipurl.com/dzz8

If you want to use VBA to set height and width in mm.

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Excel Column Width in XLSX 0
Column Width 1
Table Preferred width is changed when pasting 1
How do I create an isometric grid? 1
Total width of selected columns? 2
Dealing with a Pivot Table (when I don't want to) 0
how can we change units of column width to pixels? 0

Top