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
{count} votes

36 answers

Sort by: Most helpful
  1. Anonymous
    2019-03-13T15:48:33+00:00

    Hi mh207,

    Site Settings : Site Features : Offline Synchronization for External Lists – Enables offline synchronization between external lists and Outlook.

    The external listsreferenced above includes other Excel workbooks (pay no attention to the Outlook).  When you open your Excel workbook, a popup will appear to pull data from external sources.  And it will pull data from offline sources.

    1 person found this answer helpful.
    0 comments No comments