There may be times when you do not want a cell reference to change when copying or filling cells. You can use an absolute referenceto keep a row and/or column constant in the formula.
相对引用使用的场合比较多，但有时候也会用到绝对引用，这时候复制或者填充单元格时，单元格中的行与列的位置不会发生改变。
Recall that when you're filling out your table, you can sometimes get a maximum score in a cell from more than one of the previous cells.
回想一下，在填充表格的时候，单元格的最大值有些时候可能来自多个单元格。
Listing 11 shows the code for filling in the blank cells.
清单11显示了填充空白单元格的代码。
应用推荐