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

Question:

Question: setting up a Numbers spreadsheet

I want to group a number of collumns under one heding. How do I set this up?

Posted on

Reply
Question marked as Solved
Answer:
Answer:

Merge cells. However, not recommended.


SG

Posted on

Page content loaded

Mar 16, 2018 6:30 AM in response to ianwenro In response to ianwenro

Hi Ian,


Method 1 (not generally recommended in this forum because merged cells often lead to unforeseen problems when sorting or filtering in Numbers). You can select the cells and Menu > Table > Merge Cells.

Here is a table with two Header Rows. All the Fruit Columns are selected in Row 1.

User uploaded file

User uploaded file

Repeat for all the Vegetables Columns

User uploaded file


Method 2 (recommended).

Type the main group headings somewhere in the middle of the subgroups below.

User uploaded file

Now, select a cell with a main group heading (in this example, Fruit)

User uploaded file

Format Panel > Cell > Set the left and right Borders to No Border.

User uploaded file

Repeat for other main group headings.

Row 1 now has the appearance of merged cells but they are not merged 😎.

User uploaded file

Done!

If you have trouble centring the main group headings over the subgroup columns, please call back.


Regards,

Ian.

Mar 16, 2018 6:30 AM

Reply Helpful
User profile for user: ianwenro

Question: setting up a Numbers spreadsheet