If you have been a frequent user of Explore and DataGrids, you may have started thinking about how to manage your columns more effectively. If that is the case, you have come to the right place.

We hope, irrespective of your experience levels with Explore and DataGrids, you will take something away that you can use in your daily work. We will be looking at:

One of the most underrated features in Explore is the ability to search for and click on a column title to scroll automatically to the column. In addition, you can use any part of the column title to filter down the list of columns in the column search.

The column is highlighted and is brought into view!

CoolPlanetOS allows you two ways to hide/show columns that are relevant to your immediate work.

Sticking with the same panel, we look at the eye icon. Clicking on it toggles between hiding and showing the column in the DataGrid. You can use Tip 1 to find the columns and then hide or show them. This is great when you want to keep some columns hidden but continue using them in your Calculations and Charts.

A powerful feature, this hides all other columns other than the chart currently being viewed on the DataGrid.

Users can also hide and show an entire set of columns based on the type of column Reference, DataSource or Calculation.

Note: When added to the DataGrid, columns are added in the visible state by default.

Clicking and dragging anywhere in the column header allows you to rearrange the columns in the DataGrid.

Example: This is especially useful for logically grouping your columns.

Pinning is a great way to keep columns that are important to you always visible in the DataGrid. Clicking on the context menu allows you to "Pin Column". Columns can be pinned to the left or right. You can remove the pinning by selecting No pin in the same sub-menu. Pinned columns have a darker border than unpinned columns.

While it is useful to have pinned columns, it is crucial to remember that pinned columns do not scroll out of view; instead, they. Instead, they eat into the space available to view all columns. So, if you are using CoolPlanet OS on a low-resolution screen, use it with care.

We have found that column widths are subjective, and users set up their widths differently. This is why you have two ways to achieve this.

You can use Autosize to make the column titles fully visible. Columns can be Autosized individually or across all columns within a DataGrid. The option to Autosize columns is also available from the Actions menu in the GridBar.

Drag either edge of the column header to resize manually. All your manual changes can be reset if you go back to defaults.

Do you have other ways in which you manage your columns? We would love to hear about it and improve; let us know.