Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

A check box in Excel can use either Excel's form controls or ActiveX controls for formatting. Form controls offer simple formatting, as well as the ability to add a check box to a chart sheet or ...

Whether you're tired of losing your spot when collaborating or you want to customize the way you view your data, sheet views in Microsoft Excel are for you.

How to Create an Image of an Excel Spreadsheet. Screen-capturing programs such as the Windows Snipping tool are fine for capturing graphics you see on your screen's visible area.

Learn how to create labels in Word from an Excel list. You can easily make mailing labels from Excel list. We show you how to do it properly.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without ...

Avoid cluttering your Excel sheet with too many items Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. Creating the ...

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.