How to reference an array from another sheet in Excel?

Question

excel

Excel has a sheet with columns of numbers. If you just copy the columns to another sheet, then everything goes without problems. But if you try to make a link, then Excel starts adding 0 to the missing cells, which breaks the calculations. Is it possible to somehow create links to other sheets so that when the original arrays change, the link changes without adding extra 0's?

Answer 1

Ilya , Put this formula on the "link" sheet and stretch it out.

But if you try to make a link, then Excel starts adding 0 to the missing cells, which breaks the calculations.
...
the link was changed without adding extra 0

Keep in mind that an empty cell for calculations is still equivalent to zero.