sponsored ads
sponsored ads
1
1. Select the cells you to be able to modify.
2. Choose Home > Cells > Format > Cells.
3. Click the Protection tab.
4. Uncheck the box for Locked to unlock the cells. Check the box to Lock them. Click OK.
Answered Sep, 17 2010
1
1.Click on the cell or cells you want to lock and unlock. To lock an individual cell, click on the cell. To lock and unlock multiple cells, click on one cell, hold down the left mouse button and drag the box to include the cells you want to lock.
2.Click "Home" in Excel's top toolbar and click "Format," located in the "Cells" category of the toolbar.
3.Scroll down in the drop box and click "Lock Cell."or” Unlock Cell”
4.Protect your spreadsheet to complete the process by again clicking "Format" and then "Protect Sheet." You need a password..
0
here is a tutorail:
http://www.fanhow.com/knowhow:Freeze_Panes_to_Lock_Specific_Rows_or_Columns_in_Excel_2010_44052973
Answered Nov, 21 2010
0
Search for Related Topics
unlock ruler bar excel excel 2010 unlock filters vbscript unlock cells excel unlock filter excel unlock filters excel unlock cells excel location unlock shapes excel phpexcel unlock cells bsnl unlock cell setup unlock page breaks excel 2010 lock unlock cells excel 2010 starter unlock cell datatable qtp
Related Unresolved Questions
sponsored ads
mkv reparieren download huawei nck writer script v3.5 vedaxy audio playern73 account facebook register files hack rem software 2007 callout connector visio
Continue to downloadPower by Afreecodec.com