These formulas what difference does it

Users questions: A: A $ A: $ A $ A1: $ A555A $ 1: A $ 555A1: A555 there are other similar do?
Experts answer:A: A relative reference refers to column A; $ A: $ A refers to the absolute reference to column A; $ A1: $ A555 means the absolute reference relative reference in column A 1 ~ 555 A cell; A $ 1: A $ 555 refers to the relative reference to an absolute reference to column A 1 to 555 cells; A1: A555 refers to the relative reference A1: A555 cells. Relative references and absolute references in formulas copied to appear.
  • This information provided by the users.Thanks!