Print Page - Freezing Panes Excel

Title: Freezing Panes Excel
Post by: TheDarkKnight on 08 Aug 2016 06:22:31 AM

Hi Cognos Experts,
Is it possible to Freeze row headers in excel? vr using 10.2
Though I see this is available in HTML, not sure if its possible in excel or not?

Thanks!!
TDK

Title: Re: Freezing Panes Excel
Post by: AnalyticsWithJay on 08 Aug 2016 07:21:51 AM

Hi TDK,

There's no option to freeze row headers in Excel. If you use the IBM Cognos for Microsoft Office software, you could setup a report that could automatically refresh the data, allowing you to configure frozen headers.

Jay

Title: Re: Freezing Panes Excel
Post by: Mita on 11 Aug 2016 02:19:14 AM

Hi TDK,

You can not freeze row header in excel ..You have to do it manually after report generation.

Sasmita

Title: Re: Freezing Panes Excel
Post by: TheDarkKnight on 19 Aug 2016 08:30:04 AM

Thanks a lot for the reply. you made my job easier.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: TheDarkKnight on 08 Aug 2016 06:22:31 AM