Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 12-01-2015, 12:26 AM
macropod's Avatar
macropod macropod is offline How lock a row to prevent accidental changes Windows 7 64bit How lock a row to prevent accidental changes Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Select the cells you want to protect, then choose Format|Lock Cell then Format|Protect Sheet|OK. Done.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-01-2015, 01:30 AM
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 Locks whole sheet, not selected row(s)

Thanks Paul,
but I can't get it to work for me.
The whole sheet gets locked, not just the row(s) i wanted to protect.
And when I unlock the sheet, everything is unlocked.
I'm on version 2016, but that shouldn't be different from 2010 on things like this, right?
Reply With Quote
  #4  
Old 12-01-2015, 02:02 AM
macropod's Avatar
macropod macropod is offline How lock a row to prevent accidental changes Windows 7 64bit How lock a row to prevent accidental changes Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Sorry, I omitted a vital first step:
Select the entire sheet, choose Format|Format Cells|Protection, then uncheck the 'Locked' option.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-01-2015, 03:05 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 Yes, now it works, but I'd then want to unlock cingle rows

Yes, thanks, now it works, I can lock parts of the sheet while other parts remain editable.
I coul use that for some of what I want.
But as it seems, if I want to occasionally edit on a row in the locked portion of the sheet I see no way to unlock just that row, I have to unlock the whole sheet, right?
And to lock it again I have to go through the whole routine again.
Wouldn't be convenient enough that I'd use it much.
Or am I missing something here?
Sverk
Reply With Quote
  #6  
Old 12-01-2015, 04:42 PM
macropod's Avatar
macropod macropod is offline How lock a row to prevent accidental changes Windows 7 64bit How lock a row to prevent accidental changes Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Unprotecting unprotects the whole worksheet, so all your locked cells become editable. To re-apply the locking, simply re-apply the sheet protection - you don't need to redo the other steps.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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 02:41 AM.


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