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

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

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 ...

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.