Excel green triangle errors – have you ever come across these errors/notifications before? Watch the video to learn more

Excel green triangle errors: Excel iconThis week’s hint and tip is on Excel green triangle errors. This blog is to help you understand a little more about the little green triangle which sometimes appears in cells. These aren’t really covered in our courses so we decided to do a hint and tip on them. We are going to go through four examples of them now below.

 

Below you can download a worksheet which can be reviewed whilst watching the video. A screenshot of the worksheet can be seen below.

Excel green triangle errors: screenshot of worksheet

 

Example 1 – Unlocked Cell

In cell F3 we have an occurrence of an unlocked cell.

By default, all Excel cells are originally locked so that when a worksheet password is set on the worksheet the whole sheet is protected. Here by mistake 1 cell is unlocked so that when a password is applied there will be no protection on that cell.

By pressing the arrow next to the yellow diamond, you can lock the cell.

 

Example 2 – Inconsistent Formula

In this example cell G5 contains an inconsistent formula compared to the other formulas in column G.

It’s actually incorrect but again the yellow diamond gives you an opportunity to correct it by copying into the cell the formula from the correct cell above.

 

 

Example 3 – Error in value

In this example there is an error in the formula since a number is being multiplied by a word.

The Error in value indicates this so can step through the cells (show calculation steps) to correct it.

 

 

 

Example 4 – Apostrophe converts to text

In cell B12 I wanted to type in a phone number with a sting of numbers but it would normally miss out the leading zero (as in cell B11).

So to prevent this happening I can use an apostrophe before typing the number which converts the cell to text and shows the whole number ‘01213821415.

 

 

We hope you find these explanations helpful so you are not too worried in future about the errors you may come across with the ‘little green triangle’.

 

The video below shows you the reasons for the four examples of errors/notifications. Some of these you might know already but some you might not!

Take a look below at the video to find out more and then try them out on your own computer!

Click on button to the right to download the example spreadsheet shown in the video to try it out yourself!

We hope you have enjoyed this hint and tip on Excel green triangle errors. Why not take a look at our previous video hint and tip on the RANK and XLOOKUP functions in Excel?

For more information on Excel understanding visit our website blogs or attend one of our virtual or onsite courses.

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy