Some of the links contained in this article and website are affiliate links. This means that I may receive a commission if you click on the link and make a purchase from the affiliate. I only recommend products and services that I know or trust to be of high quality, whether an affiliate relationship is in place or not. Questions? contact@baileyrichert.com

Google Sheets beat Microsoft to the punch and introduced a Checkbox as one of the Data Validation options. You can go to Insert > Checkbox to quickly create one, and you can customize it by going to Data > Data Validation. I've updated most of the Google Sheets versions of my checklists to use that feature. I hope Excel gets smart and introduces a similar feature some day.

Shopping Cart Life Span: How soon does your shopping cart expire for anonymous users? More than a few shopping systems use Session variables for tracking cart items, and expire within hours, especially for users behind prozies that change IP addresses often, thus rendering the current Session invalid (think AOL). Several studies point to the fact that customers will wait as long as 4 days before deciding to buy, and if the item they were looking at is still in their shopping cart, you just saved them several steps and increased the possibility of conversion substantially.
Google Sheets beat Microsoft to the punch and introduced a Checkbox as one of the Data Validation options. You can go to Insert > Checkbox to quickly create one, and you can customize it by going to Data > Data Validation. I've updated most of the Google Sheets versions of my checklists to use that feature. I hope Excel gets smart and introduces a similar feature some day.
← TrazeAll Reseller License Rights Upgrade OTO by Jason Fulton Review – Best Upsell #5 of TrazeAll to Get Done-For-You Business Package And Sell TrazeAll And Keep All The Profits VideoCatalyst Software & OTO Upsell by John Gibb & Mo Miah Review – Best Multi-Purpose 3 In 1 Platform Software to Create Stunning Designs, Animations & Attention Grabbing Videos In Just A Few Clicks →
Special Unicode Characters in Data Validation Lists: ☐, ☑, ✓, ✔ - This may be my favorite approach. You can include special characters like this in a Data Validation drop-down list. This isn't quite as good as clicking once to fill in a checkbox, but it is great for the mobile Excel apps. The only hard part is remembering how to insert a check mark symbol in Excel. For more information, see my article Using Unicode Character Symbols in Excel.
×