How 2 set table size?

  • Thread starter Thread starter DEB
  • Start date Start date
D

DEB

Hi, I was wondering if someone could point me in the right direction. I need to create a table that is 5" x12" , contains 3 columns and 20 rows, and I need to lock the cells so they do not expand. Here are my questions:

How do I specify the table size of 5" x 12"?
How do lock the cell sizes?

Thank you,

Deb
 
Deb

An exact 5" by 12" table will be difficult to achieve using Excel's native row
height and column width.

Guesstimate is about the best you could get.

Row heights are measured in points. There are 72 points to an inch.

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

No relationship between the two.

If you want to use VBA to set height and width in mm....which can be converted
to inches....

Ole Erlandson has code for setting row and column dimensions.

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

As far as locking, you would Protect the worksheet so's column widths and row
heights could not be changed.

Gord Dibben Excel MVP
 
If you have access to Mac Excel 2004, you can set cell height and width
directly in inches or cm.
 
Back
Top