linking formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking Formulas

Linking Formulas

resolvedResolved · Low Priority · Version Standard

Ilker has attended:
Excel Intermediate course

Linking Formulas

How do i distinguish between formulas that have been linked from a faile - as opposed to a sheet.

RE: Linking Formulas

Hiya Ilker

Thank you for attending the course on Monday

There is an easy way to tell if a formula is linked to the sheet or a file, you will need to click on the cell that you are interested in, then go to the view menu and toolbars, then click formula auditing to reveal the auditing toolbar

then click on the trace precedents button you will then see a number of arrows pointing to cells or pointing to a mini excel spreadsheet

the one pointing to cells, is linked to the sheet and the other pointing to a mini sheet will show you its linked to another sheet or file

To find out which is which you will need to double click on the end of the arrow line, then if it a file of a sheet the name will tell you which is which

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Working with 3D formulas

You can only use fill-down if you remove $ for Absolute References.

View all Excel hints and tips


Server loaded in 0.09 secs.