In each View in SecureSheet, columns may be UnLocked, Locked or Hidden from end users who are shared to the view. Column settings may be adjusted at any time after your initial SecureSheet is created.

To see a video on adjusting column settings, click here.

Column settings are defined as:

  • UnLocked – column is visible and can be updated by user
  • Locked – column is visible and cannot be updated by user

NOTE:  Columns with formulas should be locked.

  • Hidden – column is not visible to user

Additionally, columns can be set with Filter and/or Sort settings. Filter and Sort is defined as:

  • Filter – puts a drop-down below the Column ID to filter by values in the column.

SecureSheet column settings saved and applied to the view

  • Sort – puts a link on the Column ID that allows the column to be sorted in ascending or descending order.

SecureSheet column sort direction settings in view column options

Setting Up Columns in Views

  1. Login to SecureSheet.
  2. Select the SecureSheet from your home page.
  3. Click Views. This puts you into the view design.

SecureSheet column filter settings in view configuration

  1. Select the View you want to work with from the Select a View drop-down list to work with its settings.

SecureSheet column freeze setting to lock columns during horizontal scroll        SecureSheet column header rename option in view settings

  1. Scroll through the columns and adjust the settings as you desire for the users of the View you are working in:
  1. Set the columns to UnLocked, Locked or Hidden.
  2. Click the check box to turn on/off Auto Sort / Auto Filter.

SecureSheet column order drag-and-drop reordering in views

  1. Click Save View when you are done working with the column settings.

SecureSheet hide column option in the view column settings panel

  1. Click Close to exit the view design.

SecureSheet column settings in views showing visibility and order options