Dependent Drop Down List in Excel

With Excel data validation, you can create drop down lists in worksheet cells. Show the same list all the time, or show a “dependent” drop down  list, based on the value entered  in another cell. This video shows how to set one up, and there are written steps too.

Continue reading “Dependent Drop Down List in Excel”

How to Add Emojis in Excel Worksheets

In the old days, we typed emoticons in our messages, to show a grin, or wink, etc. Now we use emojis online, and I finally learned how to add emojis in Excel too. Thanks to Wyn Hopkins who showed me this trick – my worksheets will never be the same! Also, thanks to Duncan Williamson, who shared a Sparklines trick.

Continue reading “How to Add Emojis in Excel Worksheets”