Affinity Consulting Blog


How can I see all the formulas in a speadsheet in Microsoft Excel?

Do you find yourself opening an old spreadsheet or a spreadsheet created by someone else? You look at the document and can't figure out what is data and what the formulas that are being used?

Microsoft Excel provides a simple way for you to view all the formulas in your excel document. Once you open the document, just click on the "formulas" tab and click on "Show Formulas" button (see example below). This will display all the formulas that are being used on the spreadsheet. Just click the "Show Formulas" button again and the document will go back to normal.

Let's Get Started Today

with a plan that's right for your practice.

Let Us Teach You

Take advantage of our blog resources, sign up for our law office technology white papers, take a course from Affinity University, Attend all of our Live Events.

Start Now


Hire Us To Do It For You

Hire Affinity Consulting Group to make your law office run more efficiently than ever… We can deliver the hardware, the software, and the training that is perfect to make your law office more efficient.

Start Now


Work With Us

We can give you expert guidance, helping you make smart choices for your law firm. We can help you analyze your current situation and make suggestions that will point you in the right direction.

Start Now


Sign up for our newsletter and

keep your law office efficient.

Join over 4,000 successful law firms who receive our newsletter today.

Email:

Read Our Previous Newsletters