I have other data validations set in this worksheet. When I tried what you
suggested below I got a pop up saying "contains more than one type of
validation - erase current settings and continue?" Can I do as you show
below with other validations?
--
Cassie


"Bernard Liengme" wrote:

With Data Validation
Select all the worksheet (click the square where the row headers meet the
column headers; or use CTRL+A once or twice)
With everything selected: use Data Validation | Custom and in the dialog use
this formula
=ROW()<201
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Cassie" wrote in message
...
How do I format the spreadsheet to not allow data to be entered beyond a
specified row. I have a spreadsheet that I don't want data entered below
row
201. I haven't been able to find this on any of the help searches.
--
Cassie