setting up a Numbers spreadsheet

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.

Repeat for all the Vegetables Columns

Method 2 (recommended).

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

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

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

Repeat for other main group headings.

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

Done!

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

Regards,

Ian.

Merge cells. However, not recommended.

SG