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

Why cybercriminals are targeting CPAs

This free report expands on the most commonly found scams, why education and specialized IT knowledge help to lessen security vulnerabilities, and why every firm should plan carefully for how it would respond to a breach.

PODCAST

How tax reform — and Excel — are changing the CPA Exam

Mike Decker, the vice president of examinations at the AICPA, discusses changes being made to the exam as a result of tax reform — and about how Excel will now be available for use on the test.