Microsoft KB Archive/76286

= Works: Protecting Some or All of the Data in a Works Spreadsheet =

Article ID: 76286

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 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.

Additional query words: 2.00 3.00 4.00 4.00a 4.50 4.50a w_works

Keywords: kbinfo KB76286

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.