Format on Excel

[Abdel]

Hi there,

I am experiencing trouble with formatting a report. Your help is greatly appreciated!!!

My report is an Income Statement to an excel file. I simply want to place the "Net Income" label directly under "Total Expenses". See attached screenshots for a better view.

Note: I already tried Padding but the output on excel is the same cell.

Abdel

[Abdel]

See Current Excel Format ....

[Abdel]

See Ideal Excel Format ....

[bdbits]

Is this a list or crosstab? I would guess a list, but...

[Abdel]

I think its a LIST

[bdbits]

This may work for you, kind of depends on the list structure.

Select the <#Net Income#> cell.
Select menu item Structure > Headers & Footers > Split List Row Cell.
Unlock the list (the padlock in the toolbar).
Drag and drop <#Net Income#> over one cell.