Find next empty cell action in Apple Numbers package

The Find next empty cell action in the Apple Numbers package enables you to find the next empty cell within the active or specified table on the active sheet.

Settings

  • Use one of the following options to provide session name:
    • Session name: Enter the name of the session used to open the spreadsheet with the Open action.
    • Variable: Enter the session variable that you added in the Open action.
  • Select the row or column option from the Traverse by field to specify whether you want to find the empty cell in a row or column:
    • Row: Searches horizontally from the starting cell toward the right across that row until it finds the next empty cell.
    • Column: Searches vertically from the starting cell downward in that column until it finds the next empty cell.
  • Select the Active cell or Specific cell option from the Cell position field to specify the point from where you want to start the search. If you select Specific cell option, then enter the following fields:
    • Table name: Specify the table name to find the next empty cell. For example, Table1.
    • Cell address: Specify the cell address to find the next empty cell. For example, A5.
  • Select the string variable you want to use to store the address of the empty cell from the Store cell address list.

When you specify the attributes mentioned above, the action will start at the selected cell position and traverse the table from that position until it finds the first empty cell or reaches the end of the table. If an empty cell is found in this way, it will store the address in the designated String variable. Traversing by row will start at the designated cell position and continue to the next cell in the row (for example, from B1 to C1 and so on.) until it reaches the end of the row, from which it will start in the first position of the next row. Traversing by column will begin with the designated position and continue to the next cell in the column (for example., from B1 to B2, and so on.) until it reaches the end of the column, at which point it will start in the next column in the first position.