Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-23-2013, 10:12 AM
OTPM OTPM is offline Lock column Windows 7 32bit Lock column Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Follow these steps:
1. Click on the grey box in the top left corner of the worksheet between the 1 and A to select the whole worksheet.
2. Right click anywhere on the sheet and choose Format Cells then click on the Protection tab.
3. Unselect the Locked tick box and click OK.
4. Click on the header of the column you want protecting to highlight the column.
5. Right click anywhere in the highlighted column and select Format Cells then click on the Protection tab.
6. Click in the Locked box to put a tick in it and select OK.
7. Click on the Review tab and select Protect Sheet.
8. You have the option to enter a password to protect the sheet.
9. Enter a password if you wish and click OK.
Your column will now be protected from changes.
Good luck.

Tony
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Columns. How to move the left column so it's to the right of the 'right' column ? Vit Word 9 11-21-2012 12:57 PM
Lock column Automatically enter date into a column and make that column read only Mr Davo Excel 1 10-29-2012 01:07 AM
Can I change the horizontal scrollbar to scroll smoothly rather than column by column carpat Excel 0 01-10-2012 09:34 AM
Lock column Need to search a column for a macth and return a result from a third column pdfaust Excel 2 02-03-2011 03:02 PM
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 11:24 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