chart protection

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Chart protection

Chart protection

resolvedResolved · Low Priority · Version 2003

Linda has attended:
Excel Intermediate course

Chart protection

how do i protect a worksheet and then allow part access for colleagues

Edited on Thu 4 Sep 2008, 12:49

Worksheet protection

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 2010

When 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.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips


Server loaded in 0.08 secs.