Author Topic: Format on Excel  (Read 1902 times)

Offline Abdel

  • Full Member
  • ***
  • Join Date: Apr 2015
  • Posts: 19
  • Forum Citizenship: +0/-0
Format on Excel
« on: 24 Jun 2015 03:30:16 pm »
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

Offline Abdel

  • Full Member
  • ***
  • Join Date: Apr 2015
  • Posts: 19
  • Forum Citizenship: +0/-0
Re: Format on Excel
« Reply #1 on: 24 Jun 2015 03:31:51 pm »
See Current Excel Format ....

Offline Abdel

  • Full Member
  • ***
  • Join Date: Apr 2015
  • Posts: 19
  • Forum Citizenship: +0/-0
Re: Format on Excel
« Reply #2 on: 24 Jun 2015 03:32:59 pm »
See Ideal Excel Format ....

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,787
  • Forum Citizenship: +105/-0
Re: Format on Excel
« Reply #3 on: 24 Jun 2015 05:47:03 pm »
Is this a list or crosstab? I would guess a list, but...

Offline Abdel

  • Full Member
  • ***
  • Join Date: Apr 2015
  • Posts: 19
  • Forum Citizenship: +0/-0
Re: Format on Excel
« Reply #4 on: 24 Jun 2015 05:48:00 pm »
I think its a LIST

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,787
  • Forum Citizenship: +105/-0
Re: Format on Excel
« Reply #5 on: 24 Jun 2015 05:59:29 pm »
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.

 


       
Twittear