Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

When and how is the colon used in excel? Does the sheet generate this on it's own?

3 Answers

Relevance
  • 6 years ago

    The colon denotes a range of cells in Excel. For example, A1:B2 would mean that four cells are included - A1, A2, B1, B2

  • 6 years ago

    The colon is for RANGES.

    A1:B2 includes the cells

    A1,B1

    A2,B2

  • Greg G
    Lv 7
    6 years ago

    The colon is used in range references, such as A1:A10. Excel will generate it on its own if you are using the mouse or keyboard to select the range. If you were to type:

    =SUM(

    then, either using the arrow keys or your mouse, click on A1 and drag down to A10, Excel will fill in the range:

    =SUM(A1:A10

    You can press ENTER after that, and Excel will add the closing parentheses for you.

Still have questions? Get your answers by asking now.