Get an Ampersand into an Excel Header

BY STANLEY ZAROWIN

Q. The name of my firm is Jones & Jones. But when I try to put it in an Excel header, it comes out Jones Jones—no ampersand. How can I add the ampersand?

A. I know it sounds like a silly omission on the part of Microsoft. Actually, it has something to do with the fact that Excel uses the ampersand in its command code. But there is a way to get around the problem. If you put two ampersands, one after the other with no space between them, you can fool Excel to print just one.

For those who don’t know how to set up a header in Excel, follow these steps. After creating the spreadsheet, go to File, Page Setup, Header/Footer tab and then click on Custom Header and in the right, center or left box type Jones && Jones.

You can format the name as you wish with the format A button right above the three sections. When done, click on OK .

To check that you did it correctly, go to File, Print Preview . Jones & Jones should be at the top of the spreadsheet.

SPONSORED REPORT

Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.

QUIZ

News quiz: IRS warning on cyberattacks and a change in pension rules

Once again, the IRS sounds the alarm about a threat from cyberthieves. See how much you know about this and other recent news with this short quiz.

CHECKLIST

Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.