What "!"and "$" are used for?

  • Thread starter Thread starter Ves
  • Start date Start date
V

Ves

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
 
! 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
 
Back
Top