| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
COLUMNS IN EXCEL
Hello!
Wonder if you can help? Is it possible to lock one specific column on an Excel spreadsheet without protecting the entire sheet? Thanks for your help Sarah x |
|
#2
|
|||
|
|||
|
Try this, Sarah:
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Sarah_Lecturer" wrote in message ... Hello! Wonder if you can help? Is it possible to lock one specific column on an Excel spreadsheet without protecting the entire sheet? Thanks for your help Sarah x |
|
#3
|
|||
|
|||
|
Yes.
First make sure the sheet is not protected. Then unlock all cells -FormatCellsProtection and uncheck the lock box Then select you column Lock those cells - FormatCellsProtection and check the Lock box Protect the worksheet -- HTH Bob Phillips "Sarah_Lecturer" wrote in message ... Hello! Wonder if you can help? Is it possible to lock one specific column on an Excel spreadsheet without protecting the entire sheet? Thanks for your help Sarah x |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
| Why does my excel have numbered columns and rows | Excel Discussion (Misc queries) | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Hybrid Mode
