How to insert emoji in Excel (Windows & Mac)

Want to add quick reactions or labels in your spreadsheet? Excel supports emoji on Windows, macOS, and the web. Use the built-in OS emoji pickers or formulas, then format the emoji like text. If your team still says “Office 365,” features live in Microsoft 365 today; see What is Microsoft 365 (formerly Office 365)?

Before you start

• Cells vs formula bar: Click into the cell or the formula bar before inserting emoji.
• Fonts: Windows uses Segoe UI Emoji; macOS uses Apple Color Emoji. Excel picks them automatically when you insert emoji.
• Wrap Text: Enable Wrap Text if large emoji push content outside the cell.
• Related: If the Microsoft 365 desktop entry point causes confusion on PCs, you can remove it via this guide.

Windows: Insert emoji with the emoji picker

1. Select a cell and place the cursor where you want the emoji.
2. Press Windows key + . (period) or Windows key + ; (semicolon).
3. Browse categories or search (e.g., “check,” “thumbs”).
4. Click an emoji to insert; keep the panel open to add more.
5. Press Enter to commit the cell.

Mac: Insert emoji with Emoji & Symbols

1. Select a cell or click in the formula bar.
2. Press Control + Command + Space to open Emoji & Symbols.
3. Search or browse categories, then double-click an emoji to insert.
4. Press Return to finish editing the cell.

Excel formulas: Insert emoji with UNICHAR

Use UNICHAR to insert emoji by Unicode code point (decimal). For example, the thumbs-up (👍) is 128077.

="Done " & UNICHAR(128077)

Notes: Pair with IF, TEXT, or CONCAT to build status strings. If an emoji renders as a box, update your OS/Office and ensure the cell uses an emoji-capable font.

Format, size, and alignment

• Resize: Increase the cell’s font size to scale emoji.
• Alignment: Use Middle align and Center for clean checklists or dashboards.
• Color: Color emoji keep platform colors. Font Color changes only monochrome fallback glyphs.
• Printing/PDF: Emoji export correctly in current Excel builds. Test on the target device.

Troubleshooting

• Emoji shows as a box: Switch the run’s font to Segoe UI Emoji (Windows) or update the OS to add newer emoji.
• Picker shortcut doesn’t open: Another app may intercept it. On Windows, try the Touch keyboard; on Mac, use the menu Edit > Emoji & Symbols.
• Formula shows numbers: Confirm you used UNICHAR (decimal), not CHAR.
• Cell too tall: Reduce font size or adjust Row Height and turn off Wrap Text.

Tips

• Search smarter: Try synonyms in the picker (e.g., “tick,” “check,” “thumb”).
• Data validation: Build dropdowns with labels like “Done 👍 / Blocked ⛔” to speed status updates.
• Dashboards: Use emoji sparingly for clarity—pair with text to keep meaning obvious.
• Learn the suite: For Microsoft 365 naming and bundles, share this overview.

FAQs

Can I recolor a color emoji? Not directly. They render in platform style. Use shapes/icons if you need brand colors.

Will emoji sort or filter correctly? Yes, they behave as text. Use helper columns if you combine emoji with numbers.

Do Windows and Mac show the same look? The characters match, but the style varies by platform.

Summary

1. Windows: press Win + . to open the emoji picker.
2. Mac: press Control + Command + Space for Emoji & Symbols.
3. Use UNICHAR in formulas to generate emoji (e.g., UNICHAR(128077)).
4. Resize via font size; align cells for neat lists.
5. Troubleshoot font/OS support if emoji show as boxes.

Conclusion

For quick visual cues, the OS emoji picker is fastest; formulas add automation for dashboards and status trackers. Keep sizing consistent and test exports on the device you’ll share or present from.