Forum Discussion

Deleted's avatar
Deleted
Aug 08, 2018

Freeze Row(s) and Column(s) same time

Hi, I am brand new to this......I would like to freeze the first three rows (1, 2,3) and one column (O) at the same time. I can get one, or the other, but not both; Is it possible to do this? If so, how please?

excel
  • pranav trikha's avatar
    pranav trikha
    Brass Contributor
    Aug 08, 2018

    Greetings!

    If i understand it correctly hide A to N columns, click on cell P4 and freeze panes.

    Thanks,

    • Pete Gamecho's avatar
      Pete Gamecho
      Copper Contributor
      Sep 07, 2018

      Hi,

       

      I would like to freeze columns A-L and rows 1-3. I am able to freeze one or the other but not both at the same time. 

       

      Pete

      • BobOrrell's avatar
        BobOrrell
        Iron Contributor
        Sep 07, 2018

        Select cell M4 and click Freeze Panes.  In a nutshell, you want to select the cell immediately below, and to the right of what you want frozen

Resources