Locking | search
Click here to view Locking news from 60+ newspapers.
Bookmark or Share- Split panes to lock rows or columns in separate worksheet ...To undo a split, simply click View > Window > Split again. Splitting a worksheet lets you see two regions at the same time in different panes by scrolling in each pane. It freezes panes while you scroll in one of the panes.
- Change macro security settings in Excel - Microsoft SupportIn Excel, you can change the macro security settings to control which macros run and under what circumstances when you open a workbook. For example, you might allow macros to run based on whether they are digitally signed by a trusted developer.
- Lock or unlock specific areas of a protected worksheetFollow these steps: If the worksheet is protected, do the following: On the Review tab, select Unprotect Sheet (in the Protect group). Select Protect Sheet to change to Unprotect Sheet when a worksheet is protected. If prompted, enter the password to unprotect the worksheet.
- Display or hide formulas - Microsoft SupportYou can control the display of formulas in the following ways: Switch between displaying formulas and their results from the ribbon. Switch between displaying formulas and their results from the keyboard. Prevent a formula from displaying in the formula bar. Show formulas that were previously hidden by removing protection.
- Restrict changes to files in Excel - Microsoft SupportRestrict changes in Excel. On the Review tab, in the Protect group, review the following protection options: Protect Sheet Protect the worksheet and contents of locked cells. Protect Workbook Protect the workbook for structure and Windows.
More
