To select an emoji, click on it with the pointer, or use the arrow keys to select it.
Seeing that emoji pop-up window was pretty cool, so I typed “cool”, and it found 2 emojis for me. Ooooohhh! I’d never seen that trick before, and I’ve been using Excel for approximately 150 years.
I pressed the Windows key and typed a period, and voila!Ī small window appeared, full of emojis, with instructions at the top – Keep typing to find an emoji. Full colour in Excel for web, black and white in desktopįirst thing the next morning, I tried Wyn’s tip in an Excel worksheet.
Soon after I replied to sam’s tweet, Wyn Hopkins explained how to add emojis in Excel.Įmojis work in #Excel too. That’s how I built these “Do It Yourself” replacements for Excel’s built-in Icon Sets. I was on my iPad when reading that tweet, away from Excel, but my first thought was doing something similar with Conditional Formatting, and a font like WingDings. Pshhhhh.Īnd here’s a screen shot of sam’s emoji-filled formula. I can’t sleep because I stayed up late when I discovered that I can put emojis in IF functions in my monthly #budget #spreadsheet in savings >=3000$Īnd they say scientist aren’t cool. Why did I think about using emojis in Excel? On Sunday night, Ben Collins retweeted sam, a scientist who was happy about using emojis in Google Sheets. You an learn more about emojis in this Wikipedia article, and keep reading here, to see how to add emojis in Excel. They’re little pictures, that show the expression, often with a little yellow face, like the old Smiley face.
These days, if you type one of those old emoticons, the app that you’re using will probably convert it to an emoji. Here are a few emoticons that I remember using, and you can find a longer list on Wikipedia. We didn’t complain though – it was a step up from chisels and stone tablets. In the early days of online newsgroups and bulletin boards, the hardy pioneers had to type a series of characters, to create emoticons. 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.
Now we use emojis online, and I finally learned how to add emojis in Excel too. In the old days, we typed emoticons in our messages, to show a grin, or wink, etc.