Share via

Freezing Multiple Columns & Rows in Excel (not the top row or first column)

Anonymous
2016-08-18T14:39:46+00:00

I want to be able to to freeze the 7th row of my spreadsheet whilst simultaneously freezing the first column. 

Is this possible?

Microsoft 365 and Office | Excel | For business | 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
    2016-08-19T04:52:40+00:00

    Hi Naomi,

    Yes, you can freeze the 7^th^ row and the first column at the same time. Please follow the steps:

    1. Select the cell immediately below and to the right of the rows and columns that you want to freeze. I select cell B8 in the example below:

    1. Click Freeze Panes under the Freeze panes in the VIEW tab:

    Please note that there are two separation lines.

    Here is an article for your reference: Freeze rows and columns

    Regards,

    Tisky

    30+ people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-08-19T14:06:26+00:00

    Awesome, thank you very much.

    1 person found this answer helpful.
    0 comments