Share via

Freeze Panes in Excel 2013

Anonymous
2015-03-08T19:14:34+00:00

Is there a method for Freezing multiple Rows at the top of an Excel spreadsheet, e.g. Rows 1, 2 and 3? I'm sure this was possible in Excel 2010.  The only options in Excel 2013 under the Freeze Pane Tab are 'Freeze Top Row' or 'Freeze Columns'.

It's just that I want Title and Column Headings to remain visible when scrolling down the spreadsheet.

Many thanks

Ian

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2015-03-08T19:39:58+00:00

    Freeze panes freezes all rows above and  columns to the left of the active cell when it is applied.  This has not changed.   The first menu choice to just Freeze Panes   should follow this behavior.

    If you just want to freeze rows 1, 2 and 3, then either select row 4 or select cell A4 than apply the first menu choice.  

    --

    Regards,

    Tom Ogilvy

    2 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-03-09T10:34:46+00:00

    Freeze panes freezes all rows above and  columns to the left of the active cell when it is applied.  This has not changed.   The first menu choice to just Freeze Panes   should follow this behavior.

    If you just want to freeze rows 1, 2 and 3, then either select row 4 or select cell A4 than apply the first menu choice.  

    --

    Regards,

    Tom Ogilvy

    Tom

    Good morning

    Many thanks

    Ian

    0 comments