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.


Steps

  1. 1
    To begin with, we highlight a cell. This will be a single number.
    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.
    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.
    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.
    Was this step helpful? Yes | No| I need help
  5. 5
    The same method also works with odd numbers.
    Was this step helpful? Yes | No| I need help
  6. 6
    The same method works with even numbers.
    Was this step helpful? Yes | No| I need help
  7. 7
    The same method works with days of the week.
    Was this step helpful? Yes | No| I need help
  8. 8
    The same method works with every other day of the week.
    Was this step helpful? Yes | No| I need help
  9. 9
    The same method works with letters.
    Was this step helpful? Yes | No| I need help
  10. 10
    The same method works with months.
    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.
    Was this step helpful? Yes | No| I need help

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 ask a question for more help, or 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.

User Reviews

There is no user reviews.

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 194 times.

Did this article help you?
 
x

Thank Our Volunteer Authors.

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