Breadcrumbs

How to reference a cell in one sheet from another

  1. Open the Excellentable in edit mode, go to any cell in Source sheet.

  2. In our example we are using "Transport" as the Source sheet and "Florida" as destination sheet.

    Capture 2017-05-05 at 14.14.34.png

  3. If you want to refer A2 cell from Source sheet in destination sheet, go to that sheet select the cell you want to put value in. And enter the formula :
    =SheetName!CellAddress

    Capture 2017-05-05 at 14.18.24.png

  4. After referring cell from Source sheet  to Destination sheet, value should be displayed in this cell 

    Capture 2017-05-05 at 14.21.36.png     Capture 2017-05-05 at 14.21.09.png


Using keyboard shortcuts 

  1. Initially go to excellentable in edit mode and go to any sheet select any cell 

  2. Type = and press shift key

    Capture 2017-05-05 at 14.29.24.png

  3. Go to the another sheet you want to refer and select the cell press 'Enter' key (you can select multiple cells also)

    Capture 2017-05-05 at 14.31.01.png

  4. Now you will see the value you want to refer

    Capture 2017-05-05 at 14.31.42.png

Reference sheet with multiple words

  1. Open the Excellentable in edit mode, go to a specific cell in Source sheet.

  2. In our example we are using "Transport Portals" as the Source sheet and "Boom" as destination sheet.
    multiple_word_sheet-1.png

  3. If you want to refer A2 cell from Source sheet in destination sheet, go to that sheet select the cell you want to put value in. And enter the formula :
    ='Sheet Name'!CellAddress
    multiple_cells-2.png

  4. After referring cell from Source sheet  to Destination sheet, value should be displayed in this cell
    multiple_cells-3.png multiple_cells-4.png

Reference a selected set of cells from an adjacent sheet 

  1. Open the Excellentable in edit mode, go to a specific

  2. In our example we are using "Sheet5-Banner" as the Source sheet and "Sheet3" as destination sheet.
    reference1.png

  3. If you want to reference cells A3-A5 and execute a function from the source sheet in the destination sheet, go to the destination sheet and enter the formula :
    =SUM('Sheet5-Banner'!A3:'Sheet5-Banner'!A5) 
    reference2.png

  4. After referring cell from Source sheet  to Destination sheet, value should be displayed in this cell
    reference3.png

Reference another sheet's range

  1. Open the Excellentable in edit mode

  2. Create a new sheet (Sheet3) and add A B C to A1:A3
    function_parser_1.png

  3. Pick a cell on Sheet1

  4. Choose Data→Validation

  5. Choose Formula List as the type
    function_parser-2.png

  6. Set the formula to Sheet2!A1:A3
    function_parser-3.png