Does anyone know what the 'F4' in excel (absolute cell reference possibilities) equivalent in numbers is? I really want to use this program, but not having fun doing complex spreadsheets.
To my understanding, to provide an absolute cell reference you have to use the $ sign. So if a formula or calculation will always involve cell B4, you have to enter in B$4$ or some derivative of that.