Fill Down in Numbers

Edited by Djinu, Alexander Avdeev, Eng

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
  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
  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
  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
  5. 5
    The same method also works with odd numbers
    .
    Fill Down In Numbers.mp4-canvas44 708741.jpg
    Was this step helpful? Yes | No
  6. 6
    The same method works with even numbers
    .
    Fill Down In Numbers.mp4-canvas46 865412.jpg
    Was this step helpful? Yes | No
  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
  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
  9. 9
    The same method works with letters
    .
    Fill Down In Numbers.mp4-canvas61 33554.jpg
    Was this step helpful? Yes | No
  10. 10
    The same method works with months
    .
    Fill Down In Numbers.mp4-canvas66 124578.jpg
    Was this step helpful? Yes | No
  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
    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

If you have problems with any of the steps in this article, please post in the comments section below.

Comments

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

Article Info

Categories : Macintosh

Recent edits by: Alexander Avdeev, Djinu

Share this Article:

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