Forum Discussion

Charlie_Nairn's avatar
Charlie_Nairn
Copper Contributor
Jan 18, 2021
Solved

How to freeze Rows & columns at the same time

I have Excel 365 for Mac. I need to freeze my Column A and Rows 1-3 at the same time. Excel Help says I can do this via View > Freeze Panes but in View I see no such option, only Unfreeze Panes, Free...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Jan 18, 2021

    Charlie_Nairn 

    Apparently, Freeze Panes is already active.

    So first select Unfreeze Panes from the Freeze Panes dropdown.

    Then select cell B4, and select Freeze Panes from the Freeze Panes dropdown.

Charlie_Nairn's avatar
Charlie_Nairn
Copper Contributor
Jan 18, 2021

Thanks Hans HansVogelaar 

Your faultless advice worked perfectly.

Excel help is surprisingly unclear and suggests freezing column A first - which of course freezes that column and then you can't freeze rows.

But you've explained how to freeze Excel Rows & Columns at the same time 101% clearly & accurately.

So ... THANK YOU again.

cn

Fred_Abrams's avatar
Fred_Abrams
Copper Contributor
Feb 07, 2023
I had the same problem but I still can get only half of the solution to work. Clearly I am missing the point. Sometimes I get the top row to freeze but not the left most column to freeze. Or vice a versa. Help. I used to be able to freeze both with the beta version of excel years ago but as the product evolved I could no longer accomplish the task of getting both the top row and left column freeze at the same time. Help!
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Feb 08, 2023

    Fred_Abrams 

    If the first item in the Freeze Panes drop down is Unfreeze Panes, select that.

     

    Select the cell below the last row that you want to keep visible, and to the right of the last column that you want to keep visible.

    So for example, if you want to freeze the first row and first column, select cell B2.

    And if you want to freeze the first two rows and the first three columns, select cell D3.

    Then select Freeze Panes > Freeze Panes.

     

    • FranCorona's avatar
      FranCorona
      Copper Contributor
      Jan 20, 2024

      HansVogelaar Hello, I only have these options available: 

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Jan 20, 2024

        FranCorona 

        Up to now, this discussion was about the desktop version of Excel.

        My guess is that your screenshot is from the online (browser) version of Excel.

        The wording of the options is different from the desktop version, and will change depending on the active cell.

        "Freeze at selection" will freeze the rows above the active cell and the columns to the left of the active cell.

        "Top Row" will freeze row 1.

        "Up to row 3" means that the active cell is in row 4; the rows above it will be frozen.

        If the active cell is in row 6, the item will read "Up to row 5".

        "First column" will freeze column A.

        "Up to column A" means that the active cell is in column B; the column to the left will be frozen.

        If the active cell is in column D, it would read "Up to column C".

    • BeckyBo334's avatar
      BeckyBo334
      Copper Contributor
      Jun 22, 2023
      Wonderful explanation!! Thank you so much!
      • Fred_Abrams's avatar
        Fred_Abrams
        Copper Contributor
        Jun 22, 2023
        Wow! I finally got it. If I only had a brain!
        Thank you very much!
        Fred
  • Charlie_Nairn's avatar
    Charlie_Nairn
    Copper Contributor
    Feb 08, 2023

     

    Hans Vogelaar's EXCELLENT advice of

    ‎Jan 18 2021 03:44 AM

    continues to work perfectly for me but I'm on Excel for Mac 16.69.1
    He said:-

    @Charlie_Nairn 

    Apparently, Freeze Panes is already active.

    So first select Unfreeze Panes from the Freeze Panes dropdown.

    Then select cell B4, and select Freeze Panes from the Freeze Panes dropdown.

Resources