# Worksheet Properties

Use this option to specify which filters must be set in order for new rows to be added to the Worksheet.

• Hide Grid Lines
Specifies whether to show cell borders in the grid or not.

• Is Row Selector Visible
Specifies whether the header / selector is visible or not.

• Is Row Locking Enabled
Specifies whether the user can toggle row locking on and off from the context menu.

• Is Summary Row Enabled
Specifies whether the summary row for the grid is enabled for end users.

• Allow Sorting
Specifies whether to allow users to sort the contents of the grid by clicking the column headers.

• Inline Filtering
Specifies which (if any) custom filtering options to provide to end users in the grid.

• Allowed Input Level
Use this option to specify the level at which the selected filter values must exist in order to enable editing of the Worksheet.

• Select All

Selects all rows and columns in the grid.

• Export to Excel

Exports the entire contents of the grid to Excel.

• Copy

Copies the selected cells to the application clipboard. To copy to the OS clipboard, use Ctrl+C.

• Paste

Pastes the contents of the application clipboard into the grid. To paste from the OS clipboard, use Ctrl+V.

• Insert row

Inserts a row above the right clicked row.

• Insert row below

Inserts a row below the right clicked row.

• Distribute value

Distributes a value to the selected cells, using the specified distribution method.

• Factor multiplication

Multiplies the selected cells by a factor.

• Reverse distribute evenly

Distributes the value of a cell evenly to the factors of its sum formula.

For example, given the following formula `@Total[] = @P01[] + @P02[]`, if you edit a cell in the Total column and do a reverse distribution, it will distribute the value evenly to P01 and P02.

• Reverse distribute relatively

Distributes the value of a cell relatively to the factors of its sum formula.