[gsheet, autofill, increse] 當下拉複製 SpreadSheet 公式時, 如何鎖住 cell index 的遞增?

How to control what increase of cell when user autofill the formula by drag down the cell

Using the lock symbol '$'

• Lock row: sum(E$2:E$17) // don't touch the row number 2 and 17
• Lock col: sum($E2:$E17)  // don't touch the col E
• Lock row and col: sum($E$2:$E$17)  // don't touch any thing

Reference

https://webapps.stackexchange.com/questions/28431/google-docs-speadsheet-auto-fill-control-what-increments