Skip to main content

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.



  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



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

       



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

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

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

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.


  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


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


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.
  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) 
  4. After referring cell from Source sheet  to Destination sheet, value should be displayed in this cell

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



  3. Pick a cell on Sheet1

  4. Choose Data→Validation

  5. Choose Formula List as the type



  6. Set the formula to Sheet2!A1:A3



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.