With a Grid report open, right-click over the grid and select Anaplan XL > Properties. Select the Lockdown tab to modify the lockdown options for the grid and for Excel.
| Option | Description |
| Password protect Grid properties | Before showing the Grid Properties dialog, a password is required. |
| Apply restrictions in Excel | Enforce the following permissions in Excel. If off, the restrictions are only applied when published to Anaplan XL Web Edition. |
Permissions
| Option | Description |
| Show Grid menus | Show the right-click Grid menu. Note: The Grid properties dialog is always available unless specifically excluded below. |
| Allow hierarchy navigation | Show the Hierarchy Editor for any hierarchy. |
| Can change filter/column/row members | Show the Hierarchy Editor for the hierarchies on the given axis. |
| Can drill columns/rows | Can drill columns/rows Permit drilling on members in the given axis. |
| Set All to No | Disallows all the above permissions. |
