Excel Tip: How to Type Ampersands (&) in Headers and Footers

Dave LeClair 15-06-2016

When you type an ampersand into a header or footer of an Excel document and then print it, you’ll find that it disappears, leaving you with an undesired result. AT&T becomes ATT. A&W becomes AW.


Basically, Excel Need to Learn Excel? 10 Experts Will Teach You for Free! Learning how to use Excel's more advanced features can be tough. To make it a little easier, we have tracked down the best Excel gurus who can help you master Microsoft Excel. Read More reads an ampersand as a marker that indicates that a special formatting code is to follow. Don’t worry, though, because there’s a simple trick you can use to type into your header or footer. How to Quickly Create a Custom Excel Template to Save Time Excel templates are universally useful — they can help you keep your finances in order, manage a project, and organize your life. We show you how to create your own custom template. Read More

When I tell you how simple this trick is, you’re going to be shocked. No registry hacking How to Quick Save Locations in the Windows Registry Do you visit the same locations in the Windows registry all the time? Stop manually finding their folders and jump to them in one click with registry favorites. Read More , no writing special formatting, nothing fancy.

You just need to create the header as you would normally, and when you type the text in, type two ampersands. AT&&T. A&&W. H&&R Block. You get the idea.

If you work for a company with an ampersand in its logo, this tip might just change your life (and save your job)!

What quick Excel tips do you have for us? Let us know in the comments!


Image Credit: Pixelagestudio via ShutterStock

Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.

Whatsapp Pinterest

Leave a Reply

Your email address will not be published. Required fields are marked *