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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Functions

ResolvedVersion Standard

Wed 19 Mar 2008, 16:46 Delegate Susan said...

Susan has attended:
Excel Advanced course

Functions

What have i done wrong in my function to receive the error message 'circular reference'?

Tue 25 Mar 2008, 12:17 Delegate Paul said...

RE: functions

basically, you are linking in the cell that you are typing the formula in.

if you are typing in cell A1 something like =A1*4, then it can't od that because it's looking at it's own value and it will always be going round in circles to try and get a result

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Functions

Functions

RE: functions

Excel articles

Excel tip:

Change Excel's default font