Excel blog

is the most in depth excel support blog I have yet encountered. A prime example of recommended reading for moderately familiar excel users is “10 Excel Formula Myths” which contains this gem:

8. We cannot copy a formula without changing references

Of course you can. If you want to have the same formula as in the cell above, just press CTRL+’
You will get the same formula and you can modify it as you want.

If you want to have the same formula elsewhere, just go to the formula cell, press F2, select everything (SHIFT+HOME), copy (CTRL+C).

Now go to the target cell and press F2 and paste (CTRL+V)

Might have to make up a Moodle lesson of required readings for Computing Basic Skills lecturers.

Advertisements

Comments are closed.