reference

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Reference

Reference

resolvedResolved · Low Priority · Version Standard

Vicky has attended:
Excel Intermediate course

Reference

How do I resolve a circular reference

RE: reference

Hi Vicky, Thank your for your post, Welcome to the forum, in answer to your question, first off a circular reference is where the cell which you wish to have your answer in is contained in the formula or function, to resolve the problem you will have to redo your formula or function so that the cell reference is not mentioned in it. You will get a whole heap of directions from Excel if you do create a circular reference, but to resolve the problem in the easiest and quickest way follow the steps above. best regards Pete

 

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:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips


Server loaded in 0.08 secs.