The envelope or mail symbol is a widely recognized icon used to represent mail, email, or messaging in various applications, including Excel.
It is often used in spreadsheets to signify contact information, email addresses or to visually enhance sections related to communication.
I use it when I am creating invoices or dashboards that need to show email or contact info.
In this article, I will show you some simple ways to insert the Envelope/Mail symbol in Excel.
Copy Paste Envelope Symbol From Other Places
One of the best ways to quickly get the envelope or mail symbol in Excel is to copy it from some other web page or document and paste it into a cell in your worksheet.
You can copy the envelope symbol from below:
Keyboard Shortcut to Insert Envelope/Mail Symbol in Excel
There is no direct keyboard shortcut for the envelope/mail symbol in Excel.
However, there is a keyboard shortcut to get the envelope symbol in other office applications such as Microsoft Word or Microsoft PowerPoint.
So, if you’re working with these other applications, you can use the below keyboard shortcut to get the envelope symbol and then copy it into Excel.
ALT + 9993
To use this shortcut, hold the ALT key and then press the numbers 9993 on your keypad one by one (while continuing to hold the ALT key)
Inserting Envelope/Mail using the Symbol Dialog Box
To insert the Envelope symbol in Excel using the Symbol Dialog Box, follow these steps:
- Click on the cell where you want to insert the symbol.
- Go to the Insert tab on the ribbon.
- Click on Symbol in the Symbols group.
- In the Symbol dialog box, change the font to Wingdings.
- Find the Envelope symbol, select it, and click the Insert button.
One drawback of this method is that it changes the font of the entire cell to windings, so you cannot have regular text in a cell before or after the envelope symbol.
If you want to have any text as a prefix or suffix to the envelope symbol, it is better to use the method above, where you copied from somewhere else and put it in Excel.
Inserting Envelope Symbol using Formula
You can use the below formula to get the envelope symbol in Excel.
This method is a convenient way to add the envelope symbol in Excel, especially when creating spreadsheets that involve mailing or contact information.
Wingdings Font Method to Manually Type the Envelope Symbol in Excel
Another way you can get the envelope symbol in a cell in Excel is by manually entering the star symbol (*) in a cell and then changing the font to Wingdings.
Below are the steps to do this:
- Enter * in a cell where you want the mail/envelope symbol
- Click the Home tab
- Click on the Font drop-down option.
- Select the Wingdings font option.
This will change the star character into the mail symbol.
Below is a table that summarizes all the methods to insert the Envelope symbol in Excel:
|Name of Symbol
|Shortcut for Windows
|No direct shortcut for Excel; use ALT + 9993 in Word or PowerPoint, then copy it to Excel
|Shortcut for Mac
|No direct shortcuts; copy from another source or use the Symbol dialog box
|Inserting using Symbol Dialog Box
|In Excel: Insert tab → Symbol → Choose Wingdings font → Select Envelope symbol → Insert
|Inserting using Formula
|Wingding Font Method
|Manually type * in a cell, change the font to Wingdings (Home tab → Font drop-down → Wingdings)
Other Excel articles you may also like: