Forum Discussion

freedon2's avatar
freedon2
Copper Contributor
Sep 28, 2022

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

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze 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)?

     

Resources