Forum Discussion
referencing cells from different tabs
Having an issue in Excel Online that's not the same as Excel. I'm in one tab and want to reference a cell from another tab (e.g. "=+'[tab2]'!E193" in cell b42 in [tab1]0. how do I do this in Excel ...
Hello,
first, you don't need the + sign. A formula starts with a = sign in Excel.
The syntax for referencing a cell on a different sheet is 'Sheet Name'!A1. If the sheet name contains spaces, it must be between single quotes. If it is one word, then you can omit the quotes, like
=Sheet12!A1
This works just fine in Excel online:
The square braces are used to reference external file names, not sheets in the same workbook. Sheet names cannot contain square braces.
Excel online cannot reference external files.