How to autofill cells with Numbers spreadsheet

If you're talking about filling across or down to have the cells display the active data, as in the result to a formula, simply highlight the cells with shift and the arrow keys and paste the values. Numbers is smart enough to know you're filling these cells with active data and will do this automatically. Example: You want to sum columns in the last row of your table.

• Move to the cell where your sum will go.
• Insert>Formula>Sum or calculate by hand using SUM(B2:Bx) where B is substituted for the column you're working in.
• Copy the result of the formula.
• Highlight the other cells in the row at the bottom of each column where you want this formula to be active.
• Paste.

Hope this helps.

If you want to increment a date, as in March 1, March 2, March 3… down a column, do this;

• Enter the first date into the first cell.
• Enter the Formatter pane with VO-J. Select "Cell".
• Interact with the Cell Formatter.
• Change the data type to from Automatic to Date and Time.
• Select None from the Time combo box.
• Return to the table area.
• In the cell below, enter =B2+1 where B2 is the cell you entered the first date.
• Copy the date in the cell which now has a formula in it.
• Highlight cells below and paste.