Sequence to the right with merged cells

Copper Contributor

I have merged cells in a row from C-L having 5 merged cells. I'm trying to use a sequence, =SEQUENCE(1,5,"6/12/2023",1), in those cells, but can't because they are merged. Is there any way to do this? I've seen some bypasses for going down anything for going right?

2 Replies


When working with merged cells in Excel, using a formula to populate a sequence across merged cells directly is not possible.

However, there is a workaround you can use to achieve the desired result.

Instead of directly entering the formula in the merged cells, you can enter it in a single unmerged cell and then copy and paste it across the merged cells.

Here is how you can do it:

  1. Unmerge the cells C to L: Select the merged cells (C to L), right-click, choose "Format Cells," go to the "Alignment" tab, and uncheck the "Merge cells" option.
  2. Enter the formula in cell C1: Type =SEQUENCE(1,5,"6/12/2023",1) in cell C1 (the leftmost cell of the range you want to populate).
  3. Copy the formula: Select cell C1, press Ctrl+C to copy the formula.
  4. Select the merged cell range: Select the merged cell range C1 to L1 (the entire row you want to populate).
  5. Paste the formula: Right-click on the selected range and choose "Paste Special" from the context menu. In the Paste Special dialog box, select "Formulas" and click OK.

This will copy the formula across the merged cells, populating the sequence as desired.

Please note that merging cells can sometimes create challenges when performing calculations or data manipulation. It is generally recommended to avoid excessive use of merged cells to maintain the flexibility and functionality of your Excel worksheets.


I guess it shall be something like