Fill Down in Numbers

Edited by Djinu, Alexander Avdeev, Eng, Anonymous

You're watching VisiHow. In this video, we'll show how to fill down values using Numbers on the Mac.

Fill Down In Numbers.mp4-canvas39 370028.jpg

Ad

Steps

  1. 1
    To begin with, we highlight a cell.
    This will be a single number.
    Fill Down In Numbers.mp4-canvas8 267154.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  2. 2
    We click and drag down the yellow circle.
    This will duplicate the number in the highlighted cell through a selected number of cells. The selected cell contains the number 1 in this video.
    Fill Down In Numbers.mp4-canvas19 300205.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  3. 3
    If it's a series we want to add in, we select the cells by pressing "Command" and clicking the cells to highlight them.
    There are two cells in this video.
    Fill Down In Numbers.mp4-canvas32 851143.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    Now, we can click and drag down the circle to get a series of numbers.
    Fill Down In Numbers.mp4-canvas38 942433.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    The same method also works with odd numbers.
    Fill Down In Numbers.mp4-canvas44 708741.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    The same method works with even numbers.
    Fill Down In Numbers.mp4-canvas46 865412.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    The same method works with days of the week.
    Fill Down In Numbers.mp4-canvas53 734768.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    The same method works with every other day of the week.
    Fill Down In Numbers.mp4-canvas57 890418.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    The same method works with letters.
    Fill Down In Numbers.mp4-canvas61 33554.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    The same method works with months.
    Fill Down In Numbers.mp4-canvas66 124578.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    The same method works with dates.
    We can go all the way down to see that it does start back over in the second month, February, which comes after the 31st.
    Fill Down In Numbers.mp4-canvas70 252324.jpg
    Was this step helpful? Yes | No | I need help

    Advertisement

This was how you can fill down values using Numbers on the Mac. If you have any questions or comments, please leave them in the space below. Thank you for watching VisiHow!

Video: Fill Down in Numbers

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.




Djinu
Featured Author
365 Articles Started
403 Article Edits
21,200 Points
Djinu is a featured author with VisiHow. Djinu has achieved the level of "Lieutenant" with 21,200 points. Djinu has started 365 articles (including this one) and has also made 403 article edits. 97,500 people have read Djinu's article contributions.
Djinu's Message Board
Djinu: Hi, my name is Djinu.
Djinu: Can I help you with your problem about "Fill Down in Numbers"?
 

Article Info

Categories : Macintosh

Recent edits by: Eng, Alexander Avdeev, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 175 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No