Die Tastatur von santaviga wurde wie folgt gedrückt:
Does anyone know if its possible to have a range of cells that you
can only enter a certain text. e.g. cell range is A1:F13, this range
you can only imput an X. If you try to enter anything else like any
other other letter or number it will not allow it.

This should work with Data Validity (I only have a German version).
--
Moin+Gruss Alexander - MVP für MS Excel - www.xxcl.de - mso2000sp3 --7-2