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

36 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. 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
  2. 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

    16 people found this answer helpful.
    0 comments
  3. Anonymous
    2015-10-16T17:12:06+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

    Hello,

    The article also works for online version of Excel. Please try the solution provided in the article from the example section and check if it helps.

    Thank you.

    0 comments
  4. Anonymous
    2015-10-16T18:09:34+00:00

    Hello,

    I read the articles again and tried again but no luck. There are 2 different ways in the articles you linked to. I shortened them below to the directions they give me. Again this is for the online excel and not desktop excel.

    Create a cell reference to another worksheet

    1. Click the cell in which you want to enter the formula. <--- Did this and worked
    2. In the formula bar , type = (equal sign).   <--- Did this and worked
    3. Click the tab for the worksheet to be referenced.    <--- Did this and went to other sheet
    4. Select the cell or range of cells to be referenced.    <--- Selected the cell I want and did nothing. Also hit enter and all it did was moved down to next cell. Online Excel Doesn't work like the Desktop Excel does

    Create a cell reference by using the Link Cells command

    • Make it easier to create cell references between worksheets and workbooks. The Link Cells command automatically pastes the correct syntax for you.
    • Click the cell that contains the data you want to link to.
    • On the Home tab, in the Clipboard group, click Copy . Keyboard shortcut  You can also press CTRL+C.
    • Click the cell that you want to link from.
    • On the Home tab, in the Clipboard group, click Paste . By default, the Paste Options button appears when you paste copied data.
    • Click the Paste Options button, and then click Paste Link .

    On the Online Excel below is the option I get when I click on Paste Options

    Am I still missing something??

    35 people found this answer helpful.
    0 comments
  5. 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