Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Recording a Macro

Adding a Little Animation to Your Life

Converting a Range of URLs to Hyperlinks

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

 

Adding Ampersands in Headers and Footers

Summary: Place an ampersand into the text of a page header or footer, and you might be surprised to see it missing in your printout. This is due to the way in which Excel interprets the ampersand. Here's how to get around the problem. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

The ampersand character (&) is commonly used in company names (such as Burns & Foster, Inc.) or in standard business phrases (such as Mergers & Acquisitions). If you are creating a report in Excel, you may notice that the ampersand characters don't show up properly if you add them to headers or footers for your worksheet.

The reason ampersands don't show up is because the character is used as a "marker" that indicates a special formatting code is to follow. If you want to actually use an ampersand, then you need to double it—use two ampersands, such as "Burns && Foster, Inc." Even though you enter two ampersands in the header or footer, Excel only displays one ampersand in the resulting header or footer.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2988) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Make Home Buying Less Stressful! Why make home buying harder than it needs to be? Put your mind at ease—discover all the questions you need to ask to make the best buying decision.
 
Check out Buying a Home Checklist today!