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 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!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.


IF not equal to in Excel

IF not equal to in Excel

Although it is more common to specify in Excel when something is equal to something else e.g. B1=”Sale”, occasionally it is better (and more efficient) to do the opposite i.e. if not equal to xyz then do something.

‘Not equal to’ in Excel is expressed as <> . So in the example above we could say B1<>”Sales”.

This same logic works with numbers i.e. if not the same as zero, it would be shown as B1<>0 (note that for numbers we don’t use “inverted commas”).

The ‘Not Equal to’ symbol can be used in any function that can use an logical tests e.g. IF, SUMIFS, SUMPRODUCT etc.

YouTube IF not equal to

Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.

How to tell Excel ‘not equal to’

Less than or equal to in Excel