Works: Protecting Some or All of the Data in a Works Spreadsheet (76286)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 3.0
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a
This article was previously published under Q76286

SUMMARY

You can protect some or all of the cells in a Microsoft Works spreadsheet from change with the Protect Data command. As a result, some options are automatically disabled by Protect Data (such as all of the fill, border, pattern, alignment, and number commands) to prevent any locked cells from being changed.

MORE INFORMATION

Below is a description of how to use Protect Data to protect specific data in a spreadsheet.

Protecting All Data

Works 2.0:

From the Options menu, choose Protect Data. A check mark will appear on the menu next to Protect Data, if this option is on.

Works 3.0, 4.0, 4.5, and 4.5a:

On the Format menu, click Protection. A check mark will appear on the menu next to Protect Data, if this option is active.

Protecting Some of the Data

Works 2.0:

  1. Make sure Protect Data is turned off in the Options menu.
  2. Press and hold down the CTRL key while you press the HOME key (CTRL+HOME).
  3. Press and hold down the CTRL key while you press the SHIFT and END keys (CTRL+SHIFT+END).
  4. On the Format menu, click Style. Clear the Locked check box.
  5. Select the cells to be protected.
  6. On the Format menu, click Style. Select the Locked check box.
  7. On the Options menu, click Protect Data.

Unprotect Some of the Data

  1. On the Options menu, make sure Protect Data is turned off.
  2. Select the cells to be unprotected.
  3. On the Format menu, click Style. Clear the Locked check box.
  4. On the Options menu, click Protect Data.
Works 3.0, 4.0, 4.5, and 4.5a:

Protecting Some of the Data

  1. Make sure Protect Data is turned off in the Format menu.
  2. Press CTRL+HOME (press the CTRL key and the HOME key simultaneously).
  3. Press CTRL+SHIFT+END.
  4. On the Format menu, click Protection. Clear the Locked check box.
  5. Select the cells to be protected.
  6. On the Format menu, click Protection. Select the Locked check box, and then check the Protect Data check box.

Unprotect Some of the Data

  1. Make sure Protect Data is turned off in the Format menu.
  2. Select the cells to be unprotected.
  3. On the Format menu, click Protection. Clear the Locked check box, and then check the Protect Data check box.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbinfo KB76286
©2004 Microsoft Corporation. All rights reserved.