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

G

Guest

Hi

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

Andy.
 
B

Bob Phillips

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

Sheet1!A1:A10
 
Top