Freeze panes in the active spreadsheet for the first two rows.
Freeze panes in the active spreadsheet, so that the moving part of the worksheet extends from the cell B3 to the right and downwards.
Hide the COMPUTERS worksheet.
Use KpDs as password to protect the SALES worksheet.
Display all formulas on the SALES worksheet.
Set 1234 as password to open the active workbook.
Remove the workbook protection using the password 1234.
Name the A10 cell Total.
Hide the columns B, C, D, E and the rows 6, 7, 8, 9
Display all hidden columns and rows.
Hide the IL-ates1509_1 workbook and display the IL-ates1509_2 workbook.
Group the rows 4 up to 19.
Ungroup the rows and group the columns A, B and C
Unlock the active workbook using the password 1234.
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.
On the SALES worksheet trace the precedents of the cell J20. Also, trace the dependents of the cell F9.
Set pages breaks and formulas to be displayed on the active worksheet.
Use the word code as password to protect the cell range B5:B24. Make sure the rest of the cells allow for data entry.
Insert a new Custom List including values from the cell range A2:A5.