HTML Table 169 4. Specify which column you want to sort by; then, choose Alphabetically or Numerically, and Ascending or Descending. You can set up one or two sorts to happen simultaneously and opt whether to include the first row and whether to keep the TR (Table Row) attributes with a sorted row. 5. Click OK. The selected cells are sorted, just like they are in a program such as Microsoft Excel. (Pretty cool, huh?) Importing Table Data from Other Programs Manually converting financial data or other spreadsheet information can be tedious. Fortunately, Dreamweaver includes a special feature that enables you to insert table data created in other applications, such as Microsoft Word or Excel. To use this feature, the table data must be saved from the other program in a delimited format, which means that the columns of data are separated by either tabs, commas, colons, semicolons, or another type of delimiter. Most spreadsheet and database applications, as well as Microsoft Word, enable you to save data in a delimited format, often called CSV because thats the file extension theyre given. Consult the documentation for the application youre using to find out how. After the data is saved in a delimited format, you can import it into Dreamweaver. To import table data into Dreamweaver after it has been saved in a delimited format in its native application, create a new, blank HTML page and follow these steps: 1. Choose File?Import?Tabular Data or choose Insert?Table Objects? Import Tabular Data. The Import Tabular Data dialog box appears (see Figure 6-9). 2. In the Import Tabular Data text box, type the name of the file you want to import or use the Browse button to locate the file. 3. From the Delimiter drop-down list, select the delimiter format you used when you saved your file in the other application. The delimiter options are Tab, Comma, Semicolon, Colon, and Other. You should have made this choice when you exported the data from the original program in which you created it, such as Excel. If you dont remember what you chose, you can always go back and do it again. You must select the correct option in order for your data to import correctly. 170 Part III: Advancing Your Site 4. Select the table width. If you choose Fit to Data, Dreamweaver automatically creates the table to fit the data being imported. If you choose Set, you must specify a percent or pixel size. 5. Specify the cell padding and cell spacing only if you want extra space around the data in the table to be created. 6. Choose an option from the Format Top Row option only if you want to format the data in the top row of the table. Your options are bold, italic, or bold italic. 7. Specify the border size. The default is 1, which puts a small border around the table. Choose 0 if