My Spreadsheet Lab

The site is about Microsoft Excel.

  • Home
  • Templates
  • Excel Blog
  • About Me
  • Contact Kevin

Posts Tagged → Data Validation

Word Game in Excel

posted in Formulas, Macros (vba) on April 24, 2022 by Kevin Lehrbass 6 Comments

It’s not exactly the same as Wordle but close enough 🙂

Continue reading →

Dependent Drop Down List in Excel

posted in Tips on June 5, 2018 by Kevin Lehrbass 5 Comments

A data validation drop down list has ‘Beverage’, ‘Food’, ‘Dessert’. You select ‘Food’. In the 2nd drop down list you want to see only ‘Food’ items (‘Chicken’, ‘Meatloaf’, ‘Seafood’). The 2nd list depends on the 1st. This is a dependent drop down list in Excel. I’ll explain my favorite way to solve this.  Continue reading →

Video 00120 Is the solution benefit worth the cost

posted in Solutions on February 2, 2015 by Kevin Lehrbass 0 Comments

Is the solution benefit worth the cost?

With any product there is a balance between the number of features versus the cost/performance.  Race cars and stretch limos have different features and different purposes. Continue reading →

Sometimes I write a practical 'how to' post and other times I explore a crazy idea and build something unique. I love working with data in Microsoft Excel!

Kevin Lehrbass

Newsletter