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

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
 
B

Bob Phillips

! 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
 

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

Outlook 365 overriding formatting choices 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Sub projects added as read only in Master file which are saved on sharepoint 1
How to implement two shifts per day with multiple teams 0
New computer, how do i move outlook 365 ENTIRELY? 0
How to use Macros 1
Incorporating the User Profile location into a document template path 1
How do I designate dates using info from a cooresponding drop down list? 3

Top