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

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Learn how to control Excel worksheets with spin buttons, scrollbars, option buttons, and checkboxes.

The slicer buttons don’t automatically update. How to update the button sort order in Excel Microsoft Excel won’t sort the buttons automatically — it isn’t a dynamic feature.

When collaborating in Excel, sometimes the collaboration can be distracting. Here's how to make a static image so you can do your own work without interruption.

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