In excel, what does the esclemation point (!) in a function mean?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi

It indicates the end of a sheet name. For example: =Sheet1!A16 refers to
cell A16 in Sheet1

Andy.
 
If separates a worksheet name from the range being used, such as

Sheet1!A1:A10
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What does the yellow triangle with an exclamation mark in Outlook mean? 1
What does { } mean in excel formulas? 4
What does " mean in excel 5
What does this formula mean [$-F400]h:mm:ssAM/PM 2
Case sensitivity of functions in Excel 2
What does "" mean in Excel? 2
Excel What does E mean in excel numbers? 1
Editorial GDPR: What it is and what it means 1

Back
Top