My feed
Premium

Please
or
to access all these features

Geeky stuff

In Excell, you sometimes get a little green triangle in the corner of a box, what is it?

5 replies

Katymac · 20/11/2007 21:20

Cos I want to get rid of it please?

TIA
KMc

OP posts:
Report
Katymac · 20/11/2007 21:34

Thanks the box is right......so I ignored it

OP posts:
Report
DrNortherner · 20/11/2007 21:32

I think it means that there may be an error in the formula in that cell. If you click on the cell where the green triangle is showing then you can check to see if the formula you have entered is correct.

You will also see a little icon with an exclamation mark will appear next to the cell. If you click on the icon it will allow you to select Ignore Error and the green triangle will disappear.

Report
Lizzzombie · 20/11/2007 21:31

Have any of the cells you are referencing in the formula got something weird in them?

Report
Katymac · 20/11/2007 21:29

It's not the circular one or the note(that's red I think)

It's seems to be about inaccurate formula

OP posts:
Report
Lizzzombie · 20/11/2007 21:27

I think it means there is a note attached to that cell. Hover your cursor over it until the note appears and you can delete it.

Or is that a red triangle?
Is it a circular cell reference (I totally can't remember what that means, life before baby etc...but I know it shows up sometimes and you have to clear the cell contents - not just press delete)

Report
Please create an account

To comment on this thread you need to create a Mumsnet account.