And as for using a form instead of punching numbers into ordinary spreadsheet cells, Tables once again can do the job. Here are my top 10 secrets for managing lists of data using Excel Tables. 1.

The table (data set) associated with a data form or data table is opened at build-time in browse mode. If you specify Edit for the Data Mode and Member for Lock Mode in the Attributes window of your ...

Right-click the Web form and select "View Code" to see the HTML code associated with the file. Scroll down the file to the location of your HTML table.