...
- Note: The “specimens” column has a sub-level with specimen-related column headings (specimen id, slide id, etc.). To expand the specimens column, use the scroll bar at the bottom of the table and scroll right until you get to the “specimens” column.
- Click on the expansion arrow icon to pull these columns into your table. Then select “Expand to new rows”
- You will notice that the column entries have changed from “list” to “record”. Click on the expansion arrow icon again to open the specimen column list.
- Click on “load more” to ensure all column headings from the specimens table are included, then “ok.” Notice that the number of columns and rows in your table shown at the bottom of the table have now increased.
- Please note that the entries in some columns are now duplicated – for instance for case C3L-00004, the gender and age columns are listed 3 times. This is a result of corresponding specimen IDs and slide IDs for this case being pulled into the table.
Quick Formatting Tips:
- To rearrange columns: click and highlight the column then drag to desired location.
- To select specific column headers: select “choose columns” from the home menu, then select only the column headers you would like to see. The remaining columns will be deleted.
- To remove columns: highlight the specific column and click on “remove column” from the home menu; or select “remove columns” to select multiple columns to remove) which prevent it from showing up without additional processing. We recommend simply deleting this column.
Save As Excel Worksheet
- After you have customized the table, select “Close and Load”
- Then click on "File", and "Save" to save as an Excel document
...