Limiting the number of cells/columns

[DanW]

Hey folks, I tried searching for this topic without success - I may be looking up the wrong keywords.

Is there a way to limit the number or cells and/or columns in a worksheet? (without having to hide them)

say instead of allowing A to IV columns, say limit it to A to Z.
or instead of allowing 1 to 65535 rows, say limit it to 1 to 20



thanks

dan

[Bryan Hessey]

Hey folks, I tried searching for this topic without success - I may be looking up the wrong keywords.

Is there a way to limit the number or cells and/or columns in a worksheet? (without having to hide them)

say instead of allowing A to IV columns, say limit it to A to Z.
or instead of allowing 1 to 65535 rows, say limit it to 1 to 20



thanks

dan

Hi,

A worksheet has A to IV columns and 1 to 65536 rows,

you can only 'Hide' what you do not want to see.

You can also unprotect the 20 rows you want to use, and lock (Protect) the rest against usage.

hth
---