Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


How to tell Excel ‘not equal to’

If you want Excel to check if a cell in Excel is ‘NOT equal to’ something, you can do it in one of two ways. This comes in handy when you do not want, or cannot, make use of the equals (=) to sign.

YouTube – Not Equal to in Excel

Use <> to tell Excel not equal to

not equal to sign in MS Excel

The first thing you can do is use a less than and bigger than symbol and combine them to create a not identical to. Unfortunately Excel does not allow ≠ (mathematical sign) but by using <> in a formula you are telling Excel the same thing, the logical test is that your cell reference does not match to something else.

As an example you could build an IF that says


which reads

“if cell A1 is not equal to 0, then display the word Number otherwise the word Zero”.

Use the NOT function

Another way to achieve the same thing is to use the NOT function in conjunction with an ‘equals to’.

In this case you can set up a logical test (e.g. A1=0) and tell Excel to do the exact opposite by using the NOT function i.e. NOT(A1=0).

In the IF example above we would therefore enter


For more knowledge at this level, have a look at our online Intermediate Excel course.

Excel not equal sign

Sum all the negative numbers in Excel

Excel less than or equal to

Free Understanding of using the IF function

IF not equal to in Excel

Your best matched Excel course