Tags: column, correctly, excel, freeze, function, microsoft, msdn, panes, shooting, software, titles, trouble, working

Freeze panes function does not work?

On Microsoft » Microsoft Excel

1,259 words with 2 Comments; publish: Thu, 22 May 2008 18:18:00 GMT; (30693.75, « »)

I am trying to freeze the column titles and the function is not working. I am

doing everything correctly as far as I know. Any trouble shooting tips or

possible reasons it may not be working for me?

All Comments

Leave a comment...

  • 2 Comments
    • Post the code you are using.

      Cordially,

      Chip Pearson

      Microsoft MVP - Excel

      Pearson Software Consulting, LLC

      www.cpearson.com

      "WTF" <WTF.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:77F1B696-4F4B-4FE6-96DC-FC395A42249C.excel.todaysummary.com.microsoft.com...

      >I am trying to freeze the column titles and the function is not

      >working. I am

      > doing everything correctly as far as I know. Any trouble

      > shooting tips or

      > possible reasons it may not be working for me?

      #1; Thu, 22 May 2008 18:19:00 GMT
    • Rows above and Columns left of your selected cell will be frozen.

      Select B2 to freeze row 1 and column A.

      Do not select A1 to freeze row 1 or you will get a freeze line at window center.

      Gord Dibben MS Excel MVP

      On Wed, 5 Jul 2006 10:35:01 -0700, WTF <WTF.excel.todaysummary.com.discussions.microsoft.com> wrote:

      >I am trying to freeze the column titles and the function is not working. I am

      >doing everything correctly as far as I know. Any trouble shooting tips or

      >possible reasons it may not be working for me?

      #2; Thu, 22 May 2008 18:20:00 GMT