Allow Weekend Dates Only in Excel

With Excel Data Validation, you can add rules to a data entry sheet, and control what people put in the cells. In today's example, we'll set up a cell that only allows you to enter a weekend date. Just remember that Data Validation isn't foolproof, and people can find ways around your rules.

Continue reading "Allow Weekend Dates Only in Excel"

Excel Advent Calendar No Macros

December is only 2 days away, so it's time for an Excel Advent Calendar! I've made two new versions this year, and they don't use macros, just basic Excel features. Even if you don't need an Advent calendar, take a look to see how they're set up . You might find a use for these techniques in other projects.

Continue reading "Excel Advent Calendar No Macros"

Missing Data Validation Arrows

To make data entry easier, you can create drop down lists in a worksheet, using Excel's data validation. Usually, those lists are trouble free, but sometimes the arrows disappear, for no apparent reason. See some of the reasons for that behaviour, and how to fix or avoid the problems.

Continue reading "Missing Data Validation Arrows"