You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

The Conditional Formatting task pane provides everything you need for creating, editing, and deleting rules. Use to open the task pane and work with all the Conditional Formatting rules in a selection or a sheet. task pane opens and displays the rules, scoped to your current selection.

Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.