Data entry problem

Occasional Visitor

Suddenly when I try to enter data i a spreadsheet, it is rejected on the box moves down one row. I think I may have turned something on?????

1 Reply

Hi @freedon2 


there could be several reasons for this behaviour:

- you created a data validation for a field, which rejects wrong entries

- you have activated the worksheet protection (menu "Review | Protect Sheet")


Do you get an error message and if so, what exactly does it say (maybe you could provide a sreenshot here)?