My question is very related to this https://discussions.apple.com/thread/3204532.
I just want to do the same but in merged cells, as in the picture below. Is it possible?
I see no fill handle here.
MacOS – Increase numbers by one in merged cells
iworkmacosnumbers
Related Solutions
In order to move the formula you have to drag the yellow circle on the bottom of the cell:
You should be able to Select All the cells in the sheet, then in the Format Sidebar, click the Cell tab. Then in the Fill section of the sidebar, click the color well, then select a fill option. It will say Multiple Fills. You should be able to select No Fill and delete all background (fill) colors:
Best Answer
Fill handles do not operate with merged cells. You can use a formula to achieve the same effect.
Insert the following in these cells:
A1 (the merged cells A1 and A2)
A3 (the merged cells A3 and A4)
Copy and paste A3 for the rest of the column.
The following animation shows the entire procedure: