Learn how to sum and count Excel cells by color with 3 easy methods. Save time, reduce errors, and boost your data analysis skills today ...

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.

Even if you have highlighted a range containing all the links, Excel will not open more than one at a time. To activate all the links, write a macro that runs the links from each cell in turn.

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

SEE: How to easily include dynamic dates in a Word doc using Excel (TechRepublic) How to highlight rows There’s no built-in rule that will highlight the entire record.