News

This post will show you how to filter or sort Excel data using Cell Color and Font Color the easy way. This helps organize cells & improve productivity.
Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.
Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.
In many versions of Excel, you can use a Microsoft date picker control to create an Excel date drop-down in a cell. Unfortunately, this won't work in 64-bit versions of the popular spreadsheet ...
Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.
To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.
Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.