• Excel Book Excerpt

Excel Use an Ampersand in a Header

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Use an Ampersand in a Header

Problem: I added the custom header Profit & Loss Report to my report.

LE10000718.jpg 

Figure 696 Include an ampersand in the header.

However, the actual header appears as Profit Loss Report. The ampersand is missing.

LE10000719.jpg 

Figure 697 Excel leaves out the &.

Strategy: The ampersand is a special character in the custom header and footer field. To print an ampersand in the header, you have to type && in the Header dialog box.

LE10000720.jpg 

Figure 698 Specify && while editing the header.

Having two ampersands will give you the desired heading Profit & Loss.

LE10000721.jpg 

Figure 699 Excel will print the && as a single &.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: