Select cells/columns/rows action in Apple Numbers package

The Select cells/columns/rows action of the Apple Numbers package enables you to select cell, columns, or rows of a current sheet in a spreadsheet.

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.
  • Choose from the following options to determine the data scope you want to retrieve or process:
    • Cells: If you have selected this option, select any of the following options:
      • Active cell: Enables you to select the active cell from the spreadsheet
      • Specific cell: Specify the table name for the given sheet. Choose from the following fields:
        • Cell address: Enables you to select the cell you have specified in the field. For example, A1 or C20.
        • Cell range: Enables you to select all the cells in the range you have specified in the field. For example, A4:A10.
        • All cells in the table: Enables you to select all the cells in the table.
    • Columns: If you have selected this option, select any of the following options:
      • Active column: Selects the column of the current active cell in the sheet.
      • Specific column: Specify the table name for the given sheet. Choose from the following fields:
        • Column name: Enables you to select the column you have specified in the field. For example, A.
        • Column range: Enables you to select all the columns in the range you have specified in the field. For example, A:D.
    • Rows: If you have selected this option, select any of the following options:
      • Active row: Selects the row of the current active cell in the sheet.
      • Specific row: Specify the table name for the given sheet. Choose from the following fields:
        • Row number: Enables you to select the row you have specified in the field. For example, 5.
        • Row range: Enables you to select all the rows in the range you have specified in the field. For example, 5:10.

Example

You are working on some sales data and want to view the car sales for the year 2024. Before you start building the bot, you can create the following data sets on your desktop in .xlsx format as below:
Table 1. Car sales in FY_2024
Car brand Pricing Sales per year Engine type Model
Ferrari $222,620 13,752 units Petrol -
Mercedes $178,450 19,565 units Diesel -
BMW $36,350 15,721 units Petrol -
Ford $31,920 4.5 million units Diesel Mustang
  1. Double-click or drag the Apple numbers > Open action. Select the file path that you saved on your desktop.
  2. Double-click or drag the Select cells/columns/rows action .
  3. Select the Cells tab from the Table elements field and select the option Specific cell. Enter the following inputs:
    1. Enter Car sales in FY_2024 in the Table name field.
    2. Select the option cell range and enter C4:E5 in the Cell range field. You will see that the following cell range is highlighted with a green border, indicating the active cell range selected in the table.
      15,721 units ,Petrol,-
4.5 million units,Diesel,Mustang
  4. Select the Columns tab from the Table elements field and select the option Active column. Perform the following steps:
    1. Navigate to the file you saved on your desktop and select the cell A5 (Ford) in the Car sales in FY_2024 table.
    2. Save and then run the bot. You will see the column highlighted with a green border, indicating the active range selected is from (A1:A5) in the table.
      Car brand
Ferrari
Mercedes
BMW
Ford
  5. Select the Rows tab from the Table elements field and select the option Specific row. Enter the following inputs:
    1. Enter Car sales in FY_2024 in the Table name field.
    2. Select the option row range and enter 3-5 in the Row range field. You will see that the following row range is highlighted with a green border, indicating the active row range selected in the table.
      Mercedes,$178,450,19,565 units, Diesel,-
BMW,$36,350,15,721 units, Petrol,-
Ford,$31,920,4.5 million units,Diesel,Mustang