1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Button to clear spreadhseet data

Discussion in 'iWork Forum' started by SpeedyRocketeer, Sep 8, 2011.

  1. SpeedyRocketeer
    Offline

    SpeedyRocketeer iPF Noob

    Joined:
    Sep 8, 2011
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    UK
    Ratings:
    +0 / 0
    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
    Last edited: Sep 8, 2011
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,986
    Thanks Received:
    1,852
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,996 / 1
    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.
  3. SpeedyRocketeer
    Offline

    SpeedyRocketeer iPF Noob

    Joined:
    Sep 8, 2011
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    UK
    Ratings:
    +0 / 0
    Thanks

    Thanks for the information.
  4. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,986
    Thanks Received:
    1,852
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,996 / 1
    No problem. :)

Share This Page

Search tags for this page

apple numbers empty cell not delete

,

can you add a button to clear all cells in a mac numbers spreadsheet

,

clear contents iworks numbers

,

how to clear cells numbers

,

how to clear contents in iworks numbers

,

ipad numbers clear cell contents

,

ipad numbers delete cell contents

,

ipad numbers how to clear shaded cell

,

macros in numbers ipad

,

numbers macros ipad