How to Give a Name to the Columns in Excel. The default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to ...

SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.