The article will show you some methods on how to insert symbol in Excel header. We need to use symbols to separate words or names and also we mean special things by using special symbols.
In the dataset, we have information about some people: their Names, Email Addresses, and the Company where they work.
Download Practice Workbook
4 Ways to Insert Symbol in Excel Header
1. Inserting Ampersand (&) Symbol in Excel Header
In this section of the article, I’ll show you how to insert the Ampersand (&) symbol in the header of an Excel sheet that you want to print. Let’s follow the instructions below.
Steps:
- First, select the range B2:D11 and go to Page Layout >> Page Setup Icon (marked with ** symbol)
- After that, from Header/Footer >> select Custom Header.
- The Header Wizard will show up. Type multiple words and put double Ampersands (&&) between two consecutive words. In this case, I typed Email&&Company in the Left section: You can type in other sections too if you want.
- After that, click OK.
- Then, click on Print Preview.
After that, you will see Email&Company as a header of your printing copy.
Thus you can insert a Symbol in Excel Header.
Read More: How to Insert Symbol in Excel Footer (3 Effective Ways)
2. Using Copy and Paste Command to Insert It in Excel Header
Here, I’ll show you how to use the copy and paste command to insert a symbol in the header of an Excel sheet that you want to print. Let’s follow the instructions below.
Steps:
- First, select any cell where you want to put the symbol.
- Then go to Insert >> Symbols >> Symbol
- You will see the Symbol Select any symbol as you wish. I selected the Trademark symbol (®) for this section.
- After that, press CTRL+C to copy the symbol.
- Then select the range B2:D11 and go to Page Layout >> Page Setup Icon (marked with ** symbol)
- After that, from Header/Footer >> select Custom Header.
- The Header Wizard will show up. Type multiple words and press CTRL+V to paste the Trademark symbol (®). In this case, I typed Mox&&Kingston® in the Left section: You can type in other sections too if you want.
- After that, click OK.
- Then, click on Print Preview.
After that, you will see Mox&&Kingston® as a header of your printing copy.
Thus you can insert Symbol in the Header by Copy and Paste command.
Read More: Excel Formula Symbols Cheat Sheet (13 Cool Tips)
Similar Readings
- Keep Header in Excel When Printing (3 Ways)
- Type Delta Symbol in Excel (8 Effective Ways)
- How to Remove Header and Footer in Excel (6 Methods)
- Add Currency Symbol in Excel (6 Ways)
- Insert a Picture in Excel Header
3. Using VBA to Insert Symbol in Excel Header
You can also use VBA to insert symbols in the Excel header. Let’s see the description below.
Steps:
- First, select Developer >> Visual Basic
- After that, Microsoft Visual Basic Editor will open. Select Insert >> ModuleÂ
- This operation will open the VBA Module. Type the following code in it.
Sub HeaderSymbolInsert()
ActiveSheet.PageSetup.PrintArea = Range("B2:D11").Address
With ActiveSheet.PageSetup
.Orientation = xlPortrait
.LeftHeader = Chr(64) & " JacksonBrothers "
End With
ActiveSheet.PrintPreview
End Sub
Code Breakdown
- First, we named the Sub Procedure as HeaderSymbolInsert and then set the address of the range B2:D11 as the Print Area.
- After that, we applied the WITH Statement and set the orientation of the printing copy and finally, we used the LeftHeader property to set the header The Chr(64) refers to the symbol @ and running the macro will give us the header ‘@JacksonBrothers’.
- Finally, PrintPreview will help us to see the Header in the preview
- Now go back to your sheet and Run the Macro.
You will see a preview of how your sheet will look like in the printing copy with the header @JacksonBrothers.
Thus you can insert a symbol in the header with a simple VBA code.
Read More: How to Add Symbol Before a Number in Excel (3 Ways)
4. Using Character Code to Insert Symbol in Excel Header
In this section of the article, I’ll show you how to insert a symbol in the header of an Excel sheet that you want to print using the ASCII code of that symbol. Let’s follow the instructions below.
Steps:
- First, select the range B2:D11 and go to Page Layout >> Page Setup Icon (marked with ** symbol)
- After that, from Header/Footer >> select Custom Header.
- The Header Wizard will show up. Type multiple words and then press ALT+042 (Press the ALT key the type the numbers from the Numeric keys) which will give you the Wild Card symbol. In this case, I typed Company_Details* in the Right section: You can type in other sections too if you want.
- After that, click OK.
- Then, click on Print Preview.
After that, you will see Company_Details* as a header of your printing copy.
Thus you can insert a Symbol in Excel Header.
Read More: How to Add Header in Excel (5 Quick Methods)
Practice Section
Here I am giving you the dataset that we used in this article so that you can make your own and practice these methods.
Conclusion
Finally, we can summarize that you will learn the basic idea of how to insert Symbol in Excel Header. The methods that I showed here are pretty simple and basic. If you have any questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles.
Related Articles
- How to Add Same Header to All Sheets in Excel (5 Easy Methods)
- Type Math Symbols in Excel (3 Easy Methods)
- How to Insert a Footer in Excel (2 Suitable Ways)
- Insert Date in Footer in Excel (3 Ways)
- Put a Plus Sign in Excel without Formula (3 Easy Methods)
- Insert Logo in Excel Header (4 Easy Ways)
- Type Minus Sign in Excel Without Formula (6 Simple Methods)