Family Encyclopedia >> Work

Excel Tip How to write ampersands (&) in headers and footers

When you type a sign in a header or footer of an Excel document and then print it, you will find that it disappears, leaving you with an undesirable result. AT&T becomes ATT. A&W becomes AW.

Basically Excel Do you need to learn Excel? 10 experts will teach you for free! Do you need to learn Excel? 10 experts will teach you for free! Learning to use the more advanced features of Excel can be difficult. To make it a little easier, we've tracked down the best Excel gurus that can help you master Microsoft Excel. Read More reads a sign and marker indicating that it must follow a special formatting code. Don't worry though, because there is a simple trick you can use to write AND in your header or footer. How to Quickly Create a Custom Excel Template to Save Time 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 will be surprised. No Registry Hacking How to Quickly Save Locations in the Windows Registry How to Quickly Save Locations in the Windows Registry Do you visit the same locations in the Windows registry all the time? Stop manually searching your folders and jump to them in one click with Registry Favorites. Read More

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

If you work for a company with a logo on their logo, this tip could change your life (and save your job)!

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