Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Protecting a column Protecting a column
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2016, 12:48 PM
mmp mmp is offline Protecting a column Windows 7 64bit Protecting a column Office 2010 64bit
Novice
Protecting a column 		 
Join Date: Feb 2016
Posts: 11
mmp is on a distinguished road
Default Protecting a column

Is there a way?
Reply With Quote
  #2  
Old 02-10-2016, 12:00 PM
gebobs gebobs is offline Protecting a column Windows 7 64bit Protecting a column Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
What is it you want to protect? The data? If so, use Format Cells: Protection.
Reply With Quote
  #3  
Old 02-10-2016, 02:06 PM
mmp mmp is offline Protecting a column Windows 7 64bit Protecting a column Office 2010 64bit
Novice
Protecting a column 		 
Join Date: Feb 2016
Posts: 11
mmp is on a distinguished road
Default
I want a sheet where data is entered, but just one column is blocked from having data entered. I can;t seem to find a way to do this.
Reply With Quote
  #4  
Old 02-11-2016, 09:40 AM
gebobs gebobs is offline Protecting a column Windows 7 64bit Protecting a column Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Select the entire sheet. Format Cells: Protection > Uncheck the Locked toggle.

Select the column you want to protect. Format Cells: Protection > Check the Locked toggle.

Review: Protect Sheet (enter password if you want)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protecting document brucemc777 Word 2 01-23-2016 02:38 PM
Protecting tables Elysianknight Word 1 12-11-2013 09:46 AM
Protecting documents jeljohns Word 3 09-06-2013 07:36 PM
Protecting a column Help with protecting folders?? charger shop Outlook 3 04-06-2011 02:52 PM
Protecting a column Protecting word documents elgell Word 1 03-25-2011 02:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:40 PM.

Contact Us - Privacy Statement - Top

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