Question

What character is used to separate the sheet name from the cell address within a formula containing a sheet reference?

Answer 1

The character used to separate the sheet name from the cell addres within a formula containing a sheet reference is !

For example:

Formula without sheet reference: = A1.

Formula with reference to another sheet in the same book: = Sheet1!A1

Formula with reference to a sheet in other book: = ='[Name_of_the_sheet]'!A1

That character is inserted automately so you do not have to write it.

Answer 2

Answer:

! or an Exclamation point

Explanation:

Just did the instruction on Edge 2021

Plz click the Thanks button!

<Jayla>