Interpretation of '$A$16:$A$375'? RRS feed

  • Question

  • What does "$A$16:$A$375" mean?

    Do you have any concrete example?

    Maybe you have a tutorial?


    Friday, April 3, 2015 12:09 PM

All replies

  • $A$16:$A$375 is the range of cells in column A from row 16 up to and including row 375.

    The $ symbols mean that Excel will not adjust this range if you copy the formula to another cell, or if you fill the formula down. This is called an absolute reference.

    A reference such as E16:E375, without the $ symbols, is called a relative reference. If you copy the formula to another cell, Excel will automatically adjust this range.

    See for example or for more information on absolute and relative cell references.

    Regards, Hans Vogelaar (

    • Proposed as answer by ryguy72 Friday, April 3, 2015 1:28 PM
    Friday, April 3, 2015 12:38 PM