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

Get FREE Advanced Excel Exercises with Solutions!

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.

how to insert symbol in excel header


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.

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

how to insert symbol in excel header

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

how to insert symbol in excel header

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

how to insert symbol in excel header

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

how to insert symbol in excel header

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

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

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


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

how to insert symbol in excel header

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)

how to insert symbol in excel header

  • After that, from Header/Footer >> select Custom Header.

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

how to insert symbol in excel header

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.

how to insert symbol in excel header


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

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