Cell references can let you refer to ranges of cells 单元格引用可引用单元格区域。
You refer to each cell by its location in the table 按每个单元格在表中的位置引用单元格。
Trace precedents to locate all of the cells that provide data to a formula 追踪引用单元格定位为公式提供数据的所有单元格。
Name references let you refer to cells , cell ranges , column names , or formulas by using descriptive names 名称引用允许用户用说明性名称引用单元格、单元格区域、列名称或公式。
Red arrows point from the cell that is causing the error to the cell that has the error , and blue arrows point to the precedent cells of the cell that is causing the error 红色箭头从引起错误的单元格指向含有错误的单元格,蓝色箭头指向引起错误的单元格的引用单元格。
Blue tracer arrows show cells on the active worksheet that provide data to the formula , and you can go one level deeper , tracing any cells that are referenced by the precedent cells 蓝色追踪箭头显示活动工作表中为公式提供数据的单元格,您还可以更进一层追踪由引用单元格所引用的任何单元格。