Excel: Use an Ampersand in a Header

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

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

  1. Include an ampersand in the header.

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

  2. 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.

  3. Specify && while editing the header.

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

  4. Excel will print the && as a single &.