1152

Freeze panes in the active spreadsheet for the first two rows.

1153

Freeze panes in the active spreadsheet, so that the moving part of the worksheet extends from the cell B3 to the right and downwards.

1252

Hide the COMPUTERS worksheet.

1256

Use KpDs as password to protect the SALES worksheet.

1264

Display all formulas on the SALES worksheet.

1290

Set 1234 as password to open the active workbook.

1296

Remove the workbook protection using the password 1234.

1501

Name the A10 cell Total.

1507

Hide the columns B, C, D, E and the rows 6, 7, 8, 9

1508

Display all hidden columns and rows.

1509

Hide the IL-ates1509_1 workbook and display the IL-ates1509_2 workbook.

1510

Group the rows 4 up to 19.

1511

Ungroup the rows and group the columns A, B and C

1515

Unlock the active workbook using the password 1234.

1516

Protect the active worksheet of the active workbook. Make sure the user is able to change values within the cell range C4:C7 (without setting user rights in any cell range). In case a password is asked, set 1234 as password.

1553

On the SALES worksheet trace the precedents of the cell J20. Also, trace the dependents of the cell F9.

1554

Set pages breaks and formulas to be displayed on the active worksheet.

1851

Use the word code as password to protect the cell range B5:B24. Make sure the rest of the cells allow for data entry.

1926

Insert a new Custom List including values from the cell range B2:B5.