How to show all Formulas in Excel


Ctrl tilday key

Some times when we are working in Excel, we want to study the pattern of the formulas. Why does the first function work but not the following. What has changed in the pattern of the function. This is particularly helpful when working with Absolute Cell Referencing.

To reveal all formulas created in Excel.

Press Ctrl ~ or go to the Formulas Tab and Select Show Formulas.

Offering Customized Computer Training Courses, we come to you.

Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service. Visit website reviews

Related topics

Show Formulas – YouTube

Absolute Cell Referencing

Basic Formulas

Basic Functions

Face to Face training available Sydney – Australia


About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: m: 0414 417 059
This entry was posted in Excel and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s