Deleting Columns from the Datasheet

RockWorks | Utilities | Columns | Delete Column(s)
Right-click | Delete Column(s)

Use this RockWorks command to delete one or more column of data, including the header(s), from a Utilities datasheet. This is not available in the Borehole Manager.

! Columns | Delete Column(s) is different from Edit | Delete in that it removes the entire column - data and header - from the listing. If you instead want to delete the data in the cells of a particular column or columns, but wish to leave the columns themselves and their headers intact, simply select the data to be deleted and press the Delete key on your keyboard or select Edit | Delete from the RockWorks menu.

! This tool is not available for the Borehole Manager data tables being edited as a spreadsheet, such as the I-Data or P-Data tables, because the columns are being pulled from the borehole database. See Defining I-Data Columns, Defining P-Data Columns, and Defining T-Data Columns for information about adding columns to the database.

Menu Options

• Starting Column: Verify that the column name shown here is the first (or only) column to be removed entirely from the datasheet. You may select a different column if you wish.
• Ending Column: Verify that the column name shown here is the last is the column to be deleted. If you wish to delete a single column, the Starting and Ending Column names can be the same. You can select a different column at this time if you wish.
• 
  

Step-by-Step Summary

1. Access the RockWorks Utilities program tab.
2. Open the datasheet to be edited, if necessary.
3. Click in the single column to be deleted. Or, if deleting multiple, contiguous columns, you can select cells in all of the columns.
4. Click on the Columns menu above the datasheet and select the Delete Column(s) option, or right-click and select Delete Column(s).
5. Select the names of the starting and ending columns, described above.
6. Click OK.

The program will delete the column’s data and header, moving all subsequent columns and column titles to the left. The file’s heading will be updated so that each column’s settings will be moved along with it.

RockWare home page