Button to clear spreadhseet data

[SpeedyRocketeer]

I have a very basic worksheet written in apple's program "Numbers" on my iPad. It has one column and 16 rows. In the next worksheet I have written a form to input duration (hour and min) Once I input all 16 values; the 17th row gives me sum of all durations.
Now I want to have a button somewhere. After clicking this button it should clear all input values (row 1 to 16) so that for next iteration of data entry I have all empty cells. I don't know how I can put button to clear all sixteen values. Please help.

Also is there a way to make first worksheet read only so that data entry is strictly through the form (which is the next worksheet)
and user is not allowed to modify data directly in the first worksheet.
Thanks,
Sp

 

[twerppoet]

No way to lock a table or sheet.

The clear button thing would require some kind of macro, which Numbers does not have. The best you can do is select the cells and choose Cut.

If the table has no column headers or footers, you can tap the bar above the column to select the entire column, then tap it again to get the popup menu and choose Cut. If you do have headers or footers, again tap the bar above the column to select it, then double tap the bar in the same place. The selection will shrink to the cells between the header and footer. Now tap the selected cells once for the popup menu and choose Cut.

 

[SpeedyRocketeer]

Thanks

Thanks for the information.

 

[twerppoet]

No problem.