The article will show you some methods to insert symbol in the 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: Name, Email Address, and Company.
How to Insert Symbol in Excel Header: 4 Ideal Methods
1. Inserting Ampersand (&) Symbol in Excel Header
In this section, I’ll show how to insert the Ampersand (&) symbol in the Header of an Excel sheet that you want to print.
Steps:
- Select range B2:D11 and go to Page Layout >> Page Setup Icon (marked with ** symbol).
- From Header >> Select Custom Header.
- The Header window 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.
Read More: How to Insert Symbol in Excel Footer
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.
Steps:
- First, select any cell where you want to put the symbol.
- Go to Insert >> Symbols >> Symbol.
- You will see the Symbol window.
- Select any symbol as you wish. I selected the Registered Sign (®) for this section.
- After that, press CTRL+C to copy the symbol.
- Select range B2:D11 and go to Page Layout >> Page Setup Icon (marked with ** symbol).
- From Header >> Select Custom Header.
- The Header window will show up. Type multiple words and press CTRL+V to paste the Registered Sign (®). 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.
Read More: How to Insert Sign in Excel Formula
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 Print Area as range B2:D11.
- After that, we applied the WITH statement and set the Orientation of the printing copy. Finally, we used the LeftHeader property to set the header. The Chr(64) refers to the symbol @, and running the macro will set the header @JacksonBrothers.
- Finally, PrintPreview will help us to see the Header in the preview section.
- Now go back to your sheet and Run the Macro.
You will see a preview of how your sheet will look in the printing copy with the header @JacksonBrothers.
Read More: How to Insert Tick Mark in Excel
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 using the ASCII code of that symbol.
Steps:
- First, select the range B2:D11 and go to Page Layout >> Page Setup Icon (marked with ** symbol).
- From Header >> Select Custom Header.
- The Header window will show up. Type multiple words and then press ALT + 042 (Press the ALT key and type the numbers from the Number pad) 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.
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.
Download Practice Workbook
Conclusion
Finally, we can summarize that you will learn the basic idea of how to insert a symbol in the 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.