How to Insert Symbol in Excel Header (4 Ideal Methods)

Get FREE Advanced Excel Exercises with Solutions!

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


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.

how to insert symbol in excel 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.

how to insert symbol in excel header

  • 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.

how to insert symbol in excel header

  • You will see the Symbol window.
  • Select any symbol as you wish. I selected the Registered Sign (®) for this section.

how to insert symbol in excel header

  • After that, press CTRL+C to copy the symbol.

  • Select range B2:D11 and go to Page Layout >> Page Setup Icon (marked with ** symbol).

how to insert symbol in excel header

  • 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.

how to insert symbol in excel header

  • Then, click on Print Preview.

  • After that, you will see Mox&&Kingston® as a header of your printing copy.

how to insert symbol in excel header

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.

how to insert symbol in excel header

  • 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.

how to insert symbol in excel header

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).

how to insert symbol in excel header

  • From Header >> Select Custom Header.

how to insert symbol in excel 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.

how to insert symbol in excel header

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.

how to insert symbol in excel header


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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Meraz Al Nahian
Meraz Al Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo