|
This file needs some post processing since
it is generated raw from the database. Please follow these instructions.
-
Remove/delete the first row of the
spreadsheet. It will look something similar to this (This file is created on Thu Jun 17 8:20:43 PDT 2004).
-
Select all cells of the first
title row. Change the font to bold. You can freeze this row to be non-scrolling if you like.
-
Select all cells in the spreadsheet, and then select Format - Column -Autofit Selection. Then (with all cells still selected) select Format -Cells - Alignment - Vertical = Top and enter a check in
the Wrap Text checkbox.
-
The next step is up to your personal preference. The Notes fields and a few others will be quite wide. Select these columns and adjust the widths to make them manageable (I suggest width=55).
-
Sort the file as follows: Select all cells, use Common Name a primary sort key, Tree ID as secondary and Index as third. Then Sort.
-
To save the file, the file may have quotes around the file name. Remove them. Save as Excel Workbook XLS format.
|