| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I protect only the highlighted cells in Excel?
How can I protect only the highlighted cells in Excel?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I protect only the highlighted cells in Excel?
1. select whole worksheet
2. right-click mouse and select the "format cells" option 3. click the "Protection" tab 4. untick the "locked" and press OK 5. highlight the cell the want to protect 6. right-click mouse and select the "format cells" option again 7. click the "Protection" tab 8. tick the "locked" and press OK 9. go to tools - protection - protect sheet 10. assign password 11. OK "John White" <John ¼¶¼g©ó¶l¥ó·s»D ... How can I protect only the highlighted cells in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions | |||
| How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
| stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions | |||
Linear Mode
