Question

Explain how to link between various cells in multiple work books with an example? Please don't copy from google​

Answer 1

Explanation: Press “Ctrl,” “Shift” and “Enter” simultaneously to complete the array formula. Each dependent cell is now linked to the cell in the precedent range that's in the same respective location within the range. In this example, type “=Sheet2! A1:A4” and press “Ctrl,” “Shift” and “Enter” simultaneously.