You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Merging cells mid table in Numbers

In the middle of a table I wish to put a 'brea' a row that is a explanation of the calculations below it. I want to Merge all the cells from all columns. But it seems that because the first two columns are header columns, the Merge function is greyed out.


How do I go about resolving this . I am guessing that there is some way to ' reset ' a group of select cells to default / base no formatting 'format' in order to allow me to merge these cells?


I can't find it


Help appreciated.


Thanks



Posted on Mar 17, 2022 3:25 AM

Reply
Question marked as Top-ranking reply

Posted on Mar 17, 2022 7:49 AM

It does not appear that you need the first two columns to be header columns. Make them regular columns then you can merge the columns as you wish. With the table selected, look at the sidebar (the thing with the settings on the right side of the window) and click on the Table tab. Change the number of header columns to zero. You may have to reformat the cell background of the two columns to turn them gray again. You can use Copy Style and Paste Style to get the style from a cell in the header row.

6 replies
Question marked as Top-ranking reply

Mar 17, 2022 7:49 AM in response to Neil Paisnel

It does not appear that you need the first two columns to be header columns. Make them regular columns then you can merge the columns as you wish. With the table selected, look at the sidebar (the thing with the settings on the right side of the window) and click on the Table tab. Change the number of header columns to zero. You may have to reformat the cell background of the two columns to turn them gray again. You can use Copy Style and Paste Style to get the style from a cell in the header row.

Mar 17, 2022 4:36 AM in response to Neil Paisnel

Neil Paisnel wrote:

explanation of the calculations below it.


Have you considered putting the explanation or explanations in a comment or comments (click a cell and from the menu choose Insert > Comment, or type shift-command-k)?


Comments are a good place to put information like this. Merging cells is not always a good idea because it can produce unexpected results in calculations.


SG



Mar 17, 2022 8:31 AM in response to Neil Paisnel

I had not considered or heard about that fucnti0n, but on tyron it, it is not what I'd want.


I want to be able to have them print out.


I suppose the other way would be to create multiple tables on each sheet, each with a header.

If you see the screen shot you will see what I mean.


There are no complicated calculations, just a few SUM and percentage divisions showing the split of my deceased partners estate between her 3 children and myself.


Putting an explanation between each 'stage' and the calculations below each explanation...




[Image Edited by Moderator to Remove Personal Information]

Merging cells mid table in Numbers

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