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

Cybersecurity threats proliferating for midsize and smaller businesses

This report details how SMBs can properly protect private information from breaches, design and implement a cybersecurity policy, and create safeguards for training and education.

QUIZ

News quiz: Senate health care bill in the spotlight

Reports related to the Republican bill to repeal many provisions of the PPACA, other tax issues, and the giant AICPA ENGAGE Conference offered a diverse reading list for June. See how much you know about recent news with this short quiz.