Share via

Excel Online how to reference a cell from another worksheet

Anonymous
2015-10-14T21:20:53+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

36 answers

Sort by: Most helpful
  1. Anonymous
    2015-10-15T15:57:32+00:00

    Hello, That does help for the desktop version of excel but I am talking about Excel Online. Are those feature not yet available?

    Thanks

    10+ people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2015-10-15T15:32:05+00:00

    Hello,

    Welcome to Microsoft Community and thank you for posting your query.

    You can refer the below article for more information on referencing a cell from another worksheet.

    https://support.office.com/en-us/article/create-or-change-a-cell-reference-1ac825a1-ea1b-441e-ac4d-d4a1c5514456

    Hope the information helps. Do reply if you need further assistance, we will be happy to help you.

    Thank You.

    9 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2016-03-31T12:55:34+00:00

    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

    8 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2015-11-11T06:41:20+00:00

    Hi,

    Has anyone found the solution to this yet?

    I'm having the exact same problem, neither of these directions work with Excel ONLINE!

    Frustrating as we use it all the time.

    Thanks.

    8 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2016-06-23T05:22:45+00:00

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

    6 people found this answer helpful.
    0 comments No comments