How to Insert Symbol in Excel Footer (3 Effective Ways)

If you are searching for ways to insert a symbol in Excel Footer, then this article will be helpful for you. So, let’s get into the main article.

Download Workbook


3 Ways to Insert Symbol in Excel Footer

Here, we have the records of the marks for different subjects of some students of a college. Using this datasheet we will add our desired symbol below it in the Footer section and then print the whole sheet. By following the 3 ways in the upcoming sections you can also add your desired symbols in the Footer section.

how to insert symbol in Excel footer

We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience.


Method-1: Using Page Layout Tab to Insert Symbol in Excel Footer

Here, we are going to use the Page Layout tab of Excel to insert different symbols in the Footer section of a sheet. Adding Ampersand in the Footer section is dissimilar to adding another type of symbol. The two cases will be illustrated below.


Case-1: Insert Ampersand (&) Symbol in Excel Footer

In this section, we will only discuss the process of insertion of the specific symbol Ampersand (&) in the Footer section of the following sheet. By using this symbol we will separate the name of the subjects; Physics, Chemistry, and Maths, present in this sheet.

how to insert symbol in excel footer

Steps:
➤ Select the dataset to appear in the Print Preview and then go to the Page Layout Tab >> click on the Expand icon of the Page Setup area.

ampersand

After that, the Page Setup dialog box will open up.
➤ Click on the Header/Footer section and then select the Custom Footer option.

ampersand

Then, the Footer wizard will pop up.
Among the three sections you can write anywhere you want to appear in the Footer section.
➤ We are going to type the subject names with & on the Right section, and notice that we have separated Physics, Chemistry, and Maths by 2 ampersands(&) as a separator between every 2 subjects. Because a single & will indicate the joining of two text strings but typing 2 & symbols here will result in a single & sign in the main Footer section.
➤ Press OK.

how to insert symbol in excel footer

Afterward, you will be taken to the Page Setup dialog box again.
In the Footer section, you can see the resultant view of the Footer part with each subject separated by a single Ampersand.
➤ Click on the Print Preview option to see the result.

ampersand

Finally, you will be able to add the Ampersand symbol successfully in the Footer section.

ampersand

Read More: How to Insert a Footer in Excel (2 Suitable Ways)


Case-2: Typing Character Code of a Symbol to Insert

In this portion, we will discuss the way of inserting any type of symbol except for the Ampersand symbol.

how to insert symbol in excel footer

Steps:
➤ Select the dataset to appear in the Print Preview and then go to the Page Layout Tab >> click on the Expand icon of the Page Setup area.

any other symbol with shortcut

After that, the Page Setup dialog box will open up.
➤ Click on the Header/Footer section and then select the Custom Footer option.

any other symbol with shortcut

Then, the Footer wizard will pop up.
Among the three sections you can write anywhere you want to appear in the Footer section.
➤ We are going to enter our content in the Right section and so we have added the copyright symbol by pressing the ALT key+0169 (the numbers will be pressed one by one while holding the ALT key and the numbers should be entered from the Numeric Keypad).
Here, 169 is the character code of the copyright symbol and an extra 0 should be added prior to this code here to work properly.

how to insert symbol in excel footer

➤ Enter the college name after the symbol and then press OK.

any other symbol with shortcut

Afterward, you will be taken to the Page Setup dialog box again.
In the Footer section, you can see the resultant view of the Footer part with the college name after the copyright sign.
➤ Click on the Print Preview option to see the result.

any other symbol with shortcut

Eventually, you will get the Footer section with your wanted symbol.

any other symbol with shortcut

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


Similar Readings


Method-2: Use of Copy & Paste Feature to Insert Desired Symbol

Here, we will explain the ways to add any type of symbol except for the Ampersand symbol in the Footer section of the following dataset. We will insert here the Copyright symbol but you can choose any other symbol you want.

how to insert symbol in excel footer

Steps:
➤ Select the cell where you want to insert the symbol and then go to the Insert Tab >> Symbols Group >> Symbol Option.

any other symbol with copy and paste

Then, the Symbol wizard will appear.
➤ Select the copyright (©) symbol which is from ASCII (decimal) and has a character code of 169.
➤ Click on the Insert option.

any other symbol with copy and paste

After that, we placed our desired symbol in cell C15.

how to insert symbol in excel footer

➤ Now, go to the View Tab >> Workbook Views Group >> Page Layout Option.

any other symbol with copy and paste

The following figure is showing the Page Layout view of this sheet.
➤ Copy the symbol by pressing CTRL + C and to see the Footer section scroll down the page.

any other symbol with copy and paste

Lastly, we can see the Footer section of this page, and here we have 3 sections to write the content of the Footer.

any other symbol with copy and paste

➤ Then, we have pasted the copied symbol by pressing CTRL + V in the right section.

how to insert symbol in excel footer

➤ Type the rest part of the content after the symbol which is the college name.

any other symbol with copy and paste

In this way, we have completed the task of adding a symbol in the Footer section and now we will preview the result.
➤ Select the dataset and then go to the File Tab.

any other symbol with copy and paste

➤ Select the Print Option. Instead of doing this, you can also press CTRL + P.

any other symbol with copy and paste

In this way, we have entered our desired symbol in the Footer section of the following sheet.

any other symbol with copy and paste

Read More: Excel Formula Symbols Cheat Sheet (13 Cool Tips)


Method-3: Using VBA to Insert Symbol in Excel Footer

Here, we are going to use a VBA code to add any type of symbol except for the Ampersand symbol in the Footer section of the following dataset.

how to insert symbol in excel footer

Steps:
➤ Go to the Developer Tab >> Code Group >> Visual Basic Option.

VBA Code

Then, the Visual Basic Editor will open up.
➤ Go to the Insert Tab >> Module Option.

VBA Code

After that, a Module will be created.

VBA Code

➤ Write the following code

Sub addition_of_symbol_footer()
ActiveSheet.PageSetup.PrintArea = Range("B1:D13").Address
With ActiveSheet.PageSetup
       .Orientation = xlPortrait
       .RightFooter = Chr(169) & " 'X' College "
End With
ActiveSheet.PrintPreview
End Sub

Code Breakdown

  • Here, we have named the subprocedure as addition_of_symbol_footer and then set the address of the range “B1:D13” of the active sheet as the print area.
  • After that, the WITH statement is applied to avoid the repetition of the object PageSetup every time declaring other properties.
  • Within this statement, we have set the margin of the page, the orientation of the dataset, etc. and finally, to add a symbol in the Footer section we have used the property .RightFooter = Chr(169) & ” ‘X’ College “. Where Chr(169) represents the copyright symbol (©) and then the college name will appear after it.
  • Finally, PrintPreview will help us view the Footer area in the preview section.

how to insert symbol in excel footer

➤ Press F5.
Finally, you will have the added symbol in the context of the Footer section.

VBA Code

Read More: How to Add Symbol Before a Number in Excel (3 Ways)


Practice Section

For doing practice by yourself we have provided a Practice section like below in a sheet named Practice. Please do it by yourself.

practice


Conclusion

In this article, we tried to cover the ways to insert a symbol in Excel Footer. If you have any suggestions or questions, feel free to share them in the comment section. For more Excel-related articles you can explore our Exceldemy site.


Related Articles

Tanjima Hossain

Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo