What "!"and "$" are used for?
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 |
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 |
All times are GMT +1. The time now is 11:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com