- 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.
Figure 696 Include an ampersand in the header.
However, the actual header appears as Profit Loss Report. The ampersand is missing.
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.
Figure 698 Specify && while editing the header.
Having two ampersands will give you the desired heading Profit & Loss.
Figure 699 Excel will print the && as a single &.
For more resources for Microsoft Excel: