What "!"and "$" are used for?
! is the separator between a sheet name and a range reference such as in
Sheet1!A1:A20
I suppose it makes parsing the formula simpler.
$ is use with a cell reference to make it absolute. For instance, if you
enter =A1 in cell B1 and then copy that down, B2 will change to =A2, B3 to
=A3 and so on. But if you enter =A$1 in B1 and copy down, B2 will also say
=A$1, as will B2, as will B3, and so on.
HTH
Bob
"Ves" wrote in message
...
Hi there!
I regret my ignorance, but can you please mak eit clear, what "!"and "$"
are
used for? What is the purpose for these symbols?!
I am new in this matter- work with MS Excel... :-(
Thanks in advance!
Ves
|