98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in london - Protecting cells
excel training in london - Protecting cells
Resolved · Low Priority · Version Standard
Karen has attended:
Excel Pivot Tables course
Protecting cells
I wish to send out a protected worksheet, but allow the user to change font and to widen or colour in certain columns when they return the worksheet to me. How should I do this please?
Thanks
Karen
RE: Protecting cells
USE THE FOLLOWING TO LOcK CELLS:
Cells are protected with a two stage process.
By clicking on format > cells, then navigating to the PROTECTION Tab, you will see a tick box saying locked.
All cells are locked by default, but are only activated once you switch the functionality on.
To do this, click on TOOLS > PROTECTION > PROTECT SHEET.
All cells are locked by default, so your would need to unlock the cells you do not want to protect.
HOWEVER:
before you confirm the password, tick the relevant box to enable the formatting functionality.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Rotating Text in an Excel 2010 WorksheetMaybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting! |