Q. I often use watermarks in Microsoft Word to indicate that the document is a “Draft” or “Confidential.” However, the options to create a watermark are not in Microsoft Excel. I want to indicate that ...

Applying direct formatting to spilled arrays in Excel could cause issues if the data changes shape or size. Formula-based conditional formatting rules allow for automatic formatting adjustments when ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...

How to add a conditional format that highlights groups in Excel Your email has been sent The article, How to use a border to discern groups more easily in Microsoft Excel, shows you how to use a ...

Turn generic columns into custom visuals by adding floating totals, nesting series, and layering simultaneous data labels.

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

Dropdowns are useful features that simplify data entry and enforce data validations in spreadsheet software. Creating a dropdown list is easy. And you might have done that already in Excel. But did ...