Skip to Content

Planning View : EPM Formatting

Jun 29, 2017 at 03:44 PM


avatar image
Former Member

Hello Team,

We are re-using the UNIPA05 Planning view Templates for our development. As per the below image, if we can divide the planning view template in to 4 quadrants, we don't want to waste much of the excel space for Q1 and Q3.

I mean to say, we have very few planning levels in any of our to-be planning view templates and very high numbered time buckets in Q4


i) How can i minimize the Columns widths in Q1 (Column A to J) without impacting the EPM formatting? Especially the Lists, Text-boxes and Filters formatting in Q1 ?

When i tried to minimize the column width and saving the template again forcibly, Upon refresh its auto adjusting to its original widths. Is there any way to do the column width formatting

Please suggest



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Jul 03, 2017 at 01:53 PM

Check Auto Fit Column width from EPM-->Options-->Sheet Options-->Formatting.

Or Uncheck this option and adjust column width in the spread sheet as per your requirement this setting will remain even after refresh.

10 |10000 characters needed characters left characters exceeded