Forum Discussion
freedon2
Sep 28, 2022Copper Contributor
Data entry problem
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
Sort By
- Martin_WeissBronze Contributor
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)?