Books on Excel
You can buy any of the books below by clicking on its Amazon [affiliate] link.
The older books can be picked up at a Half-Price Bookstore, but make sure the CD disk is attached inside the back flap because it contains example files and an electronic version of the book.
Excel 2010 Bible
Excel Dashboards & Reports
Excel 2010 Tips & Tricks
Excel 2010 Formulas
Excel 2010 Power Programming with VBA
Excel 2003 Inside Out
{ 3 comments… read them below or add one }
How to protect a specified cells or a columns in a work sheet with password?..
Am using Excell -2010.
If i use a “Format Cell” + Locked , Protect Sheet password . it will not allow to enter the values in anyone of the cell unless i enter the password.
Pls suggest
The cells you want people to enter data have to be un-locked. Select those cells, and bring up the Format Cells dialog box (Ctrl+1) and select the Protection tab, then uncheck the box beside Locked and click OK. Next you have to protect the sheet by choosing Tools > Protection > Protect Sheet. You don’t have to enter a password for this to work.
Now each cell you un-locked is free to have data entered on your protected sheet.
Excel working styles