A Substitute for the Hard-to-Reach Equal Sign

BY STANLEY ZAROWIN

Why don’t computer manufacturers put an equal sign (=) in a more convenient place on keyboards? It’s such a pain to find that out-of-the-way key we use in so many Excel formulas.

The answer is simple: Keyboard designers aren’t accountants. But cheer up, here’s a simple work-around. When you enter a formula, Excel—which does know the habits of accountants—immediately recognizes that you’re writing a formula. So it lets you go to your favorite geography on the keyboard, the numeric keypad, and use its plus (+) key instead of the main keyboard’s =.

If you type +(C1+C2) and press Enter , Excel adds the requisite = and ignores the + in the calculation. Notice that both the + and the = appear in the formula bar, but Excel includes only the = in its calculation (see screenshot).

SPONSORED REPORT

2018 financial reporting survey: Challenges and trends

Learn the top reporting challenges that emerged in a survey of more than 800 finance, accounting, and compliance professionals across the world, and compare them with your organization's obstacles.

PODCAST

How the skill set for today’s CFO is changing

Scott Simmons, a search expert for large-company CFOs, gives advice for the next generation of finance leaders and more, including which universities are regularly producing future CEOs and CFOs.