Data entry problem

Copper Contributor

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)?