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.


Excel formula changes to RC reference (and doesnt work)

Under a very specific set of circumstances, starting a cell with a plus causes other Excel formula to change to RC reference (and don’t work because they are typed in like text).

YouTube Formula changes to RC reference

Starting Excel formula with + (don’t do it)

So if you are old school and start formulas with a +, and you’ve just learnt to group sheets you could be experiencing this problem.

Below we have grouped 3 sheets and now want to enter the same formula (units x selling price) into the same cell on all 3 sheets. Note that we have started the formula with a + so it says +C1*C2

excel formula changes to RC reference

In this case when we click enter, on the sheet we are on, it works fine. But if you now look at the other sheets you will see that in place of a formula with the answer we have +R[-2]C*R[-1]C entered as text.

excel formula changes to RC reference

This seems to only happen when you use a multiplication. Although it might be obscure, it is fairly likely as an inexperienced user may just have learnt how to group sheets and multiplication is a fairly common requirement.

Main lesson- don’t start a formula with a +, ever. Start always with an = sign so Excel knows you mean to enter a formula.

For other reasons not to start with a +, see the Don’t start with a + in Excel post.

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.

Don’t use + to start an Excel formula

Start of month formula in Excel

The problem with starting excel formula with plus