Column Heading formatting Question

[smooveb]

Hi,

is it possible to put take two column headings and merge them? Or it is possible to take two column headings, and split the row to create a parent heading for the two? Example:

Col 1 Col 2 Merged Heading for Cols 3/4 Col 5
Col 3 Col 4

Hope this looks right when posted! Thanks everyone,
B

 

[ATP]

If you select a specific cell in the heading, it can be resized or deleted and not affect the main table.

You can then alter the formula in the heading to concatenate the require headings/values.

e.g. =NameOf(<Item>) + &quot;/&quot; NameOf(<Description>)

 

[smooveb]

Excellent! But could I put a 'line break' in that formula as well?
B

 

[ATP]

You can only do this by editing the formula in the cell.

Double click the header so that you are editing the formula in the cell.

to put the line break in you need to press <CTRL> + <RETURN> in a string.

e.g. &quot;Heading 1&quot; + &quot;<CTRL><RETURN>&quot; + &quot;Heading 2&quot;

This will look like this in when editing the cell:

&quot;Heading 1&quot; + &quot;
&quot; + &quot;Heading 2&quot;

But will display this in the cell:
Heading 1
Heading 2