You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). You can also specify the name of the sheet.
您可以自己决定是采用绝对地址（如 $A$1）还是相对地址（如 A1）或是综合型地址（A$1 或 $A1）来表示引用的单元格，还可以指定工作表的名称。