"How to" perform common Excel actions in Numbers chart? Does one exist?

Hi Monty,

Monty Hampton wrote:

Actually, I cannot determine how to fill identical content. If there is a number in it, it wants to perform some function (e.g. IMBC02 copies as IMBC03). Formulas seem to fill down fine.

I also discovered the fill down option available when you first select the cells of origin (orange dot dragging), but it seems to behave similarly.

Also, anyone know if one can add Fill Down to right click options?

Thanks.

Give Numbers a hint by filling in two cells with the same value.

Select both cells and drag the yellow dot (the Fill Handle) down

Regards,

Ian.

Given a single example, Numbers will automatically increment a series of a series of single letters, a series of day names, month names, or a text string ending in a number.

Given two samples in consecutive cells, Numbers will do the same thing, incrementing by the amount set by the difference between the first two examples.

To place the same number into all cell of a column, enter the same number in two consecutive cells, select both cells, then drag the fill control down the column. The number values will still be incremented as they are filled down, but with an increment value of zero, the values won't change from row to row.

Regards,

Barry

Select the cell. Cmd C (copy). Select the cells where you want to paste it. Cmd V (paste).

I do not know how to add fill down to the right-click menu.

I do not know how to override Numbers' auto-incrementing when filling down/across with text/numbers it thinks should be incremented. I notice that Excel is wishy-washy on how it does it. In Excel, if you drag down on a cell (which is also called filling down), it does the same thing Numbers is doing but if you use the Fill Down menu command it does what you are asking.

For your next trick, try different types of series 😉

Regards,

Ian.