If you drag the box in the lower right corner of the active cell to select a range of cells, $[officename] automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a &quot; $ &quot; sign to designate it as an absolute reference.
如果拖动活动单元格右下角的框以选择单元格区域，$[officename] 将自动在相邻单元格中插入相应的引用。因此，将在工作表名称前加上“$”符号以将其指定为绝对引用。