Apple Vision Pro is now available in the U.S.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Merged Cell

I'm unable to check/uncheck tickboxes in merged cells. I'm also unable to drag merged cells to fill down (or across).


Can I assume this is a known limitation without a solution?

iMac (24-inch, M1, 2021, 2 ports)

Posted on Sep 17, 2022 5:57 PM

Reply
Question marked as Best reply

Posted on Sep 17, 2022 6:28 PM

I have no problem checking/unchecking checkboxes in merged cells. I've tried horizontally merged, vertically merged, and a combination with no problem. I tried merging then formatting as checkbox and I tried it the other way around, still no problem. There may be something you are doing that I am not.


You cannot drag-fill merged cells. It seems like you should be able to but you cannot. I don't know if it is a bug or a limitation. You can copy/paste instead.

2 replies
Question marked as Best reply

Sep 17, 2022 6:28 PM in response to Winston Churchill

I have no problem checking/unchecking checkboxes in merged cells. I've tried horizontally merged, vertically merged, and a combination with no problem. I tried merging then formatting as checkbox and I tried it the other way around, still no problem. There may be something you are doing that I am not.


You cannot drag-fill merged cells. It seems like you should be able to but you cannot. I don't know if it is a bug or a limitation. You can copy/paste instead.

Sep 17, 2022 6:34 PM in response to Badunit

Odd about the tick boxes. Still, I think I'll abandon the merged cell approach and stick with multiple tables on the same sheet. Dragging to fill several columns and lines simultaneously is significantly more efficient than copying them. It's something I do a lot of, so by the end of the project, it represents quite a lot of time.

Merged Cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.