Worksheet setup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Old Red One - 24 Sep 2006 21:24 GMT

How do I set up a new worksheet overall 180 x 240 mm with cells 37 x 30 mm?

Reply to this Message

Gord Dibben - 24 Sep 2006 23:13 GMT

A worksheet contains 65536 rows and 256 columns, no more no less.

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 in mm.

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

You would then just hide the columns and rows you did not want to be viewed.

BTW 180 x 240 = 43200 sq. mm

37 x 30 = 1100 sq. mm per cell

43200 / 1100 = 38.9 cells

One or more of your parameters will have to be altered.

Perhaps if you describe what you are trying to achieve, some other method could
be devised.

Gord Dibben Excel MVP

>How do I set up a new worksheet overall 180 x 240 mm with cells 37 x 30 mm?

Gord Dibben MS Excel MVP

Reply to this Message

Old Red One - 25 Sep 2006 01:23 GMT

>A worksheet contains 65536 rows and 256 columns, no more no less.
>
[quoted text clipped - 37 lines]
>
> Gord Dibben MS Excel MVP

Thank you for your prompt response, and the references. I haven't yet read
them, but will.

I hoped to use EXCEL to lay out an album page for 15 stamps (Canadian
Jubilees, if you perchance are a collector); it seemed like a fun exercise,
a learning experience, and a challenge. So far I've constructed a
page-equivalent Worksheet of 84 rows 16.50 high, and five colums 33.71 wide.

As a newby I'm not familiar with VBA>

Again thanks for you help.

Reply to this Message