You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Autofill sequence of dates

How do I autofill a sequence of dates? The dates are one week apart.

Mac mini, macOS 12.6

Posted on May 23, 2023 6:39 AM

Reply
Question marked as Top-ranking reply

Posted on May 24, 2023 4:51 AM

Numbers does, in fact, have that function.


You can quickly fill cells, or a row or column, with the same formula, data, or a logical sequence of data—for example, a series of numbers, letters, or dates.

Autofill cells

Do one of the following:

  • Autofill one or more cells with content from adjacent cells: Select the cells with the content you want to copy, then move the pointer over a border of the selection until a yellow autofill handle (a dot) appears. Drag the handle over the cells where you want to add the content.
  •  
  • Any data, cell format, formula, or fill associated with the selected cells is added, but comments aren’t. Autofilling overwrites existing data with the content you’re adding.
  • Autofill cells with sequential content or patterns from adjacent cells: Type the first two items of the series in the first two body cells (not header or footer cells) of the row or column you want to fill; for example, type A and B. Select these cells, move the pointer over a border of the selection until a yellow autofill handle (a dot) appears, then drag the handle over the cells you want to fill.
  • You can also autofill cells using a pattern of values. For example, if two selected cells contain 1 and 4, the values 7 and 10 are added when you drag over the adjacent two cells (values are incremented by 3).

Autofilling doesn’t establish an ongoing relationship among cells in the group. After autofilling, you can change the cells independently of each other.

When you autofill cells, any formulas that refer to those cells are updated automatically to use the new value.



This info can be found in Numbers by clicking Help and typing "autofill dates".

(Numbers v11.1 in macOS Catalina)



6 replies
Question marked as Top-ranking reply

May 24, 2023 4:51 AM in response to sarajane290

Numbers does, in fact, have that function.


You can quickly fill cells, or a row or column, with the same formula, data, or a logical sequence of data—for example, a series of numbers, letters, or dates.

Autofill cells

Do one of the following:

  • Autofill one or more cells with content from adjacent cells: Select the cells with the content you want to copy, then move the pointer over a border of the selection until a yellow autofill handle (a dot) appears. Drag the handle over the cells where you want to add the content.
  •  
  • Any data, cell format, formula, or fill associated with the selected cells is added, but comments aren’t. Autofilling overwrites existing data with the content you’re adding.
  • Autofill cells with sequential content or patterns from adjacent cells: Type the first two items of the series in the first two body cells (not header or footer cells) of the row or column you want to fill; for example, type A and B. Select these cells, move the pointer over a border of the selection until a yellow autofill handle (a dot) appears, then drag the handle over the cells you want to fill.
  • You can also autofill cells using a pattern of values. For example, if two selected cells contain 1 and 4, the values 7 and 10 are added when you drag over the adjacent two cells (values are incremented by 3).

Autofilling doesn’t establish an ongoing relationship among cells in the group. After autofilling, you can change the cells independently of each other.

When you autofill cells, any formulas that refer to those cells are updated automatically to use the new value.



This info can be found in Numbers by clicking Help and typing "autofill dates".

(Numbers v11.1 in macOS Catalina)



Autofill sequence of dates

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.