Display And Print Formulas In Excel

BY STANLEY ZAROWIN

Q. Many of my spreadsheets contain very long and complex formulas I need to examine from time to time. Of course if I place my cursor over a cell I can see formulas in the formula box, but that’s not enough. Is there a way to see many formulas all at once so I can make any necessary adjustments?

A. There is—and you even can print an entire worksheet that displays all the underlying formulas rather than the data. To transform the display from data to formulas (see screenshot below) press Ctrl+~(tilde). Toggle back to the data view by pressing those keys again. If you wish, you can print the worksheet, with or without the formulas, as you do to any Excel file.

 

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.