Anonymous
Anonymous asked in Computers & InternetSoftware · 1 decade ago

In excel i do not want to type numbers from 1 to 100 is there a way that i can?

5 Answers

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    Simple way is to write a few numbers, 1,2,3,4, and the select them all. If you take ur cursor at the bottom right corner of the selected box, a + sign will appear. Hold the left click of the mouse and drag this plus sign down to wherever you want. It will give u the remaining numbers.

    • Commenter avatarLogin to reply the answers
  • 1 decade ago

    You can use the "Fill Series" feature in Excel to do this.

    Click on the "Edit" menu, then click "Fill", then click "Series".

    The link below will take you to a tutorial that shows you how to use the Fill Series dialog box.

    • Commenter avatarLogin to reply the answers
  • Me
    Lv 4
    1 decade ago

    write 1,2,3 on three cells, select those cells, take the right bottom corner of them, drag the small black square to get the number 100

    • Commenter avatarLogin to reply the answers
  • 1 decade ago

    a1 = "1"

    a2 = "= (a1+1)" without the quotation

    then copy a2. select a3 to a100 and paste.

    • Commenter avatarLogin to reply the answers
  • How do you think about the answers? You can sign in to vote the answer.
  • 1 decade ago

    explain more throughly pl0x

    • Commenter avatarLogin to reply the answers
Still have questions? Get your answers by asking now.