 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2005LOCK columns
Hi. Can the contents of columns in Excel be locked (as in ACCESS) to prevent accidental changes to the data? Thanks. Have you considered looking in HELP index for protection?  SignatureDon Guillett SalesAid Software donaldb@281.com > Hi. Can the contents of columns in Excel be locked (as in ACCESS) to prevent > accidental changes to the data? Thanks. Rebecca By default all cells are locked when the sheet is protected. Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked" and OK. Select the cells you wish to lock and Format>Cells>Protection. Check "locked" and OK. Now Tools>Protection>Protect Sheet. Gord Dibben Excel MVP >Hi. Can the contents of columns in Excel be locked (as in ACCESS) to prevent >accidental changes to the data? Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.