The template row allows you to quickly fill in columns of your spreadsheet. If a cell in the template row has a value or formula, every cell in that column of the main body of the spreadsheet will be given the same value or formula. If a cell in the spreadsheet already has a value, that value will be preserved.
Using the "#" notation to specify rows is recommended. See Referencing Spreadsheet Cells () for more information.