View Single Post
 
Old 11-30-2015, 03:29 PM
Sverk Sverk is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Nov 2015
Posts: 3
Sverk is on a distinguished road
Default How lock a row to prevent accidental changes

Hi, I'm quite new to making Excel 2016 sheet tables.
When I've entered data in a record (row) I'd want to lock it with a simple click to prevent accidental changes to it.
And the opposite, to unlock it if and when I need to make changes.
I'm the only user.
I've noticed that on long rows, many columns, it is too easy to enter a change or addition on an adjacent row, especially if it is in an out-to-the right column.
Thus, once a row is finished i'd want to lock it, for a while.
Is there a way to do that?
Sverk
Reply With Quote