Skip to Content
author's profile photo Former Member
Former Member

Formatting column headers of a SEM-BPS layout


I'm trying to format header column width (both characteristics & key figures) in the manual planning layout, but whenever I click on save, they are being reset to normal positions.

this is what I've done.

--> went to manual planning layout change mode

--> unchecked the default flag for "Always fit column width" ['Fit Column width Automatically' button]

--> highlighted header row

--> went to 'Format Cells' [right click]

--> checked the flag "Wrap Text" in Alignment tab

Now, the layout looks the way I want.

when I click on save, all the headers are being reset to earlier positions.

Let's say One of column header is in the following format.

Cost in US Dollars

I'm trying to get the column heading as follows.

Cost in

US Dollars

But, after necessary modifications to layout and when i click on save, format is being lost and column header is as follows.

Cost in US Dollars

Even am trying to change the header text font style to "BOLD". This is also not working.

Am i missing something?

Appreciate any help.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2005 at 06:41 PM

    I solved it.

    For formatting a cell, rather than right clicking, I chose EXCEL MENU FORMAT -> STYLE --> MODIFY and it works as expected but I wonder why it doesn't work if i do the same by right click menu.

    anyhow, hope it will be helpful for few others.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.