Calc Merge/Unmerge not in context menu (Solution)

[walrooz]

Calc’s context menu was not showing Merge or Unmerge.

I found this:

"Merge Cells" and "Split Cells" greyed out and not shown in context menu

I was editing a simple spreadsheet and suddenly Merge and Split disappeared. There are several existing merged cells, so I tested to see if I could split them and it was no-go. I had already merged a few cells, horizontal, vertical and a block of cells and then the options disappeared. I tried closing LO completely and bringing it back, but it was the same. Then I brought up some older spreadsheets and created a new speradsheet and could could Merge and Split with no problem, but if I saved …

Which shows that if — Edit > Track Changes > Record — is enabled, then it will not show.

This was not my case.

For me, I had — View > Page Break — selected

Switching back to — View > Normal — fixed the issue.

Just wanted to share in case anybody has the same issue.

Best of luck!