Tom’s Tutorials For Excel: Entering an Ampersand in Your Header or Footer
If you’ve ever wondered why a custom header or footer does not show an ampersand (
&) when you want to show it, there’s a small trick to making that happen. All it takes is two ampersands in succession, in order to show a single one.
For example, suppose you want a custom footer to be
This & That. When setting up your custom footer, you need to actually enter
This && That.
Here are the steps.
You will return to the Page Setup dialog to confirm the look of your custom footer text. I circled in red what it looks like in this example. Simply click the OK button to confirm your custom footer text.