Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-30-2015, 03:29 PM
Sverk Sverk is offline How lock a row to prevent accidental changes Windows 7 64bit How lock a row to prevent accidental changes Office 2016
Novice
How lock a row to prevent accidental changes
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet Lock medavidcook Excel 1 03-06-2014 09:33 AM
How lock a row to prevent accidental changes Lock column bray Excel 2 04-04-2013 06:51 AM
Accidental automatic indent? markg2 Word 8 12-10-2012 06:45 PM
accidental upgrade to outlook 2010 Kevin Catley Outlook 1 07-21-2012 05:11 AM
Lock a Slide Pemberton PowerPoint 0 07-18-2010 04:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft