Keyboard Shortcut for Auto-fill in Numbers

Once I enter a date or number sequence, how can I auto-fill the remaining cells to the end of the row without dragging the fill handle? Is there a keyboard shortcut to jump to the end of the row in my table?

MacBook Pro with Retina display, macOS Sierra (10.12.3)

Posted on Jun 26, 2018 12:08 PM

Reply

Similar questions

6 replies

Jun 27, 2018 7:31 AM in response to ynkeecajun

HI yc,


There is a keyboard shortcut (command-down arrow) to jump to the last cell in a column, but it does not include selecting the cells in between or performing any action on those cells.


If you use a formula to create the values for the numerical or date series, you can fill the formula (and the calculated series) into the full column using these steps:

In the first non-header cell of the column:

  • type = to open the formula editor.
  • enter the formula that will calculate the value for the current cell. Such formulas often include ROW() as a means of incrementing the value in each row).
  • Click the green checkmark to confirm the formula.
  • With the cell still selected, press command-C to Copy the formula.
  • Double-click the column reference tab to select all cells in the column except cell in header or footer rows.
  • Paste. (command-V)
  • (to replace the formulas with the calculated values…)
  • With the column still selected, Copy, then
  • Go Edit (menu) > Paste Formula Results.


Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Keyboard Shortcut for Auto-fill in Numbers

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