Ask Question
17 September, 18:52

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

+1
Answers (1)
  1. 17 September, 19:10
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “What character is used to separate the sheet name from the cell address within a formula containing a sheet reference? ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers