Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Chart protection
Resolved · Low Priority · Version 2003
Linda has attended:
Excel Intermediate course
how do i protect a worksheet and then allow part access for colleagues
Hi Linda
Sorry for the delay in answering this question.
One of the possibilities in Excel is to lock the spreadsheet from change but leave some parts unlocked. To do this:
1. On the worksheet highlight the cells to be unlocked.
2. Select the Format menu and click Cells.
3. In the Format Cells dialog box click the Protection tab and uncheck the Locked check box. Click OK.
4. Select the Tools menu, Click Protection and the click [b]Protect Sheet
|
Excel tip:How to apply the same formatting and data to multiple sheets at the same time in Excel 2010When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others. |
We'll call during UK business hours
Server loaded in 0.08 secs.