Identify Excel Cells Containing Formulas

BY STANLEY ZAROWIN

Q. Is there a way to command Excel to highlight all the cells in a worksheet that contains formulas?

A. Sure. Just click on Edit , Go To and then Special , which is at the bottom of the screen.

That opens the Go To Special screen (see screenshot below). Click on Formulas .

When you click on OK , the cells that contain formulas will be highlighted in dark blue and look like this:

SPONSORED REPORT

The technology assessment engagement

Are you working with the best technology? Do you know how to help your clients determine if their technology stack measures up? In this free report, J. Carlton Collins, CPA, explains how to answer those questions via a technology assessment engagement.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.