How to fill down with Numbers Autofill on Mac

If yous use Apple Numbers for your spreadsheet application, thence yous mightiness already move familiar alongside the Autofill feature. This handy tool lets yous speedily fill upwards other cells alongside information from side past times side ones. You tin give notice fill upwards things similar patterns, words, together with numbers, up, down, left, or right. But when it comes to filling downwardly together with yous accept hundreds or thousands of rows, it tin give notice teach tricky.

This tutorial shows yous 2 ways that yous tin give notice fill upwards downwardly alongside the Numbers Autofill characteristic on Mac for pocket-size spreadsheets equally good equally large ones.

Fill downwardly inwards Numbers past times dragging

If yous accept a smaller spreadsheet, the Autofill dragging
method is a quick together with like shooting fish in a barrel trend to go.

1) Select the
cell(s) that yous desire to fill upwards down.

2) When yous see
the pocket-size xanthous circle on the bottom prison theater cellular telephone border, click. This volition highlight
that entire prison theater cellular telephone or grouping of cells inwards yellow.

3) Use your mouse
or trackpad to drag downward the give away of cells that yous desire to fill upwards and
release when yous finish.

Note that yous tin give notice utilisation this if yous desire to practise a pattern.
For instance, yous may accept a prison theater cellular telephone alongside the give-and-take January. Follow the steps above
and yous tin give notice accept each calendar month next that fill upwards down. The same goes for numbers
or letters.

Fill downwardly inwards Numbers without dragging

If yous accept a really large spreadsheet, the dragging method tin give notice move trend likewise like shooting fish in a barrel together with mightiness non fifty-fifty move possible without errors. Give the below method a drive instead.

1) Select the
column that yous desire to fill upwards down.

2) Deselect the
header past times belongings Command and
clicking it.

3) From the menu,
click Table > Autofill Cells > Autofill Down.

This volition populate all rows downward to the cease of your
spreadsheet. And again, yous tin give notice utilisation this for patterns, formulas, words, or
whatever yous postulate to populate.

Fill across inwards Numbers on Mac

If yous desire to fill upwards columns instead, whether for a pocket-size or large spreadsheet, both of the inwards a higher house methods work.

If yous utilisation the dragging method, simply select your cell(s) and
drag to the correct or left equally needed.

If yous accept a large canvass together with desire to fill upwards across without
dragging, simply follow those steps inwards a higher house together with direct Table > Autofill Cells
> Autofill Right (or Autofill
Left) from the card bar.

Wrapping it up

The Numbers Autofill characteristic is an extremely handy i that lets yous fill upwards your cells speedily together with cut back the peril of errors inwards your data. It’s specially convenient when you’re working alongside formulas together with functions that yous postulate to re-create throughout your spreadsheet.

Are at that spot whatsoever features of Numbers that you’re having problem using or simply postulate about tips on using them better? Let us know!

Share this post