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

protection

ResolvedVersion Standard

Laura has attended:
Excel Intermediate course

Protection

How do I unlock cells

RE: Protection

Dear Laura

Thank you for attending Excel 2007 Intermediate course. I hope you enjoyed the training.

There are 65,536 rows and 256 columns in one worksheet in Excel 2000, 2002, and 2003. It means that they are 16,777,216 cells in one sheet and by default they all are locked. So once you protect your worksheet the user is not allowed to enter any data in those cells.

In Excel 2007 the rows numbers have increased to 1,048, 576 rows and 16384 Columns.

The main reason for unlocking cells is so that once you have protected the entire sheet you can allow the user to edit information in the unlocked cells.

To unlock cells please follow these steps:

Step 1: Select all the cells that you wish to allow the user to edit after protecting the sheet.
Step 2: Right-click within the selected range and select [b]Format Cells

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.