Documentation
What is it?
Column Visibility can show or hide columns within a worksheet in Excel. You can view which columns are visible or hidden based on a user defined row containing predefined column header names. You can also save and retrieve the defined visibility. |
Utility Definitions: |
|
List Window: Double click on a row in the list window to change its visibility Column Row: The values from the row entered in the Column Row field will be displayed in the Column Name's column within the listing window Selected Visible: Changes the columns of the selected rows within the list window to Visible Selected Hidden: Changes the columns of the selected rows within the list window to Hidden Selected Reverse: Selecting Reverse reverses the visibility of the columns of the selected rows within the list window. If a column is hidden it becomes visible, if a column is visible it becomes hidden. Saved Settings: The saved settings field is used to save or retrieve visibility settings Retrieve: Select Retrieve after selecting a previously saved setting from the Saved Settings field to retrieve a previously saved visibility setting Save: Select Save after entering a name in the Saved Settings field to save the visibility settings set in the current list window Delete: Select Delete to delete the saved setting entered in the Saved Settings field  Select the button when you want to refresh the utility to the active worsheet's columns |