How to Add Emojis to Excel (And Have Them Change in Response to Your Data)

But why not make your spreadsheet a little more lighthearted by using emojis within your formulas?

To do this for Peter, we would key in

in cell C2.

If you’re using a Windows computer, press Windows+.

Emojipedia

(the Windows key and the period key).

If you’re using a Mac, press Ctrl+Cmd+Space.

This will bring up a list of emojis it’s possible for you to use within your formula.

Table in Excel containing three columns. The first is employee names, the second is their profit, and the third is blank.

Then end the quotation marks and parentheses, and press Enter.

Finally, use the AutoFill function to complete the rest of your results.

A table in Excel displaying Yes or No depending on the outcome of the IF logical test.