The answer is simple. We specify the table range by using Absolute addressing. This means that the address is a fixed position and Excel shouldn't change it. To change a cell address to an absolute address, put a "$" in front of each piece of it that you want to stay unchanged.

Like this:

• Relative address: A1
• Absolute address: $A$1