Excel Online how to reference a cell from another worksheet

Question

Can you reference another cell on another worksheet? I click the equals sign in a cell then go down to the bottom and choose another tab and click on the cell I want and hit enter but it doesn't work. If I want to reference another cell in the same worksheet than that works fine. Anyway besides typing the formula all out?

Answer 1

As of March 2016, this issue still persists.

I have tried this process using Edge on a windows 10 machine and Chrome on a Mac with the exact same results as outlined above.

I hope this is an item that will be resolved.

MV

Answer 2

Hi there, me too was looking for an answer/solution to the very same problem. I was randomly entering words, like manually typing "=Sheet2!E2" etc but it didn't work, then I wrote "=Value(Sheet2!E2)" and you know what!? It worked! hope the same will work for you too if you are still looking for a solution!

Answer 3

This is a very annoying and glaring issue for excel on-line. It really crimps usability.

Answer 4

I figured out another way. You have type a function like this:

='[SheetReference]'![Cell reference]

So if you are on Sheet 2 trying to reference cell D4 from Sheet 1 you type:

='Sheet 1'!D4

Answer 5

if you right click the cell you want to place the reference in and select "Hyperlink"

you can then choose "Place in this document:" and type the location

ex. SHEET2!A1