Is there and easy to address cells on a different work sheet

[semajjames]

Hi
I have learned how to names cells so that they can be addressed from a different work sheet ,,,,

But it seems really quite a long process and i have to do it very often, is there no way a cell can be address from a different work sheet just by clicking it or something similar

cheers

[zbor]

Just press = and then select desired sheet and desired cell and press enter

Your formula will look at that cell, for example =Sheet2!C10

[semajjames]

goodness i don't know why that didn't work when i tried before !!!

thanks