Share via

Can you freeze rows and colums in the Excel Online?

Anonymous
2015-10-16T15:27:50+00:00

Moderator: changed title from "OneDrive" to "Excel Online"

I am using the OneDrive Excel but I cant freeze the rows or columns.  I know you can do it on standard software packages but can you do it on the Drive.??

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

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-10-31T19:01:23+00:00

    I can freeze the top row or the left column, but, not both at the same time.  You basically have to toggle back and forth.  Is there a way to freeze both at the same time?

    yes, click the cell where you want both top and side to freeze, example: click cell b3, then click freeze panes, then it will freeze the top and side panes

    70+ people found this answer helpful.
    0 comments
  2. Anonymous
    2017-08-23T07:41:01+00:00

    It is August 2017 - I just tested it with Excel online 

    View  >> Freeze Panes >> Freeze Top Row

    and it works! (:

    40+ people found this answer helpful.
    0 comments
  3. Anonymous
    2017-10-15T17:46:31+00:00

    I tried it yes you can

    10+ people found this answer helpful.
    0 comments
  4. Anonymous
    2017-01-02T11:00:13+00:00

    You can't.  Should be able to but can't, and apparently the creator has no intention of sorting it out.  The best you can do is duplicate the headings every 30 lines or so, depending on screen size.  

    So in cell A30 type the simple formula           =A1                and then drag it across to fill in the rest of the headings.  You will have to repeat this every 30 lines or so.  

    It's a bodge, but probably more help than you're about to get from MS.

    7 people found this answer helpful.
    0 comments
  5. Anonymous
    2015-10-16T16:20:03+00:00

    Sadly you cannot freeze panes directly in Excel Online, however if you freeze the pane in Excel 2013 or Excel 2016 then that feature will sync up to Excel Online and you can still edit the spreadsheet, you can't remove or edit that feature though. I tested this with Excel 2013 and the spreadsheet displays the frozen pane in Excel Online, I just can't modify which columns are frozen until I open it in Excel 2013 again.

    7 people found this answer helpful.
    0 comments