Follow this blog

Monday, September 5, 2011

Fixed row in excel

How to fix row or column in Excel so when you scroll up or down this row remain locked? In this short tutorial you will find an answer. Usually users need to fixing top row in excel.

Fixed row in Excel 2010


  • Select row in Excel which you want to be first non fixed row (row 2 in example, because we want to freeze row 1)

  • Sample Excel selection for freeze row







  • Click View tab, then click Freeze panes icon and choose Freeze panes

    Freeze panes option for fix row







  • That's it, now you have fixed (locked) top row in excel!

  • For top row you can just use Freeze Top Row option

Fix row in earlier versions of Excel

To get a fixed row, highlight the row where you wish all rows before the selected row to be fixed or locked, go to Window>"Freeze Panes" and you will see a line appear across your worksheet. Everything above the line is fixed and will remain viewable till you scroll down your worksheet.


No comments: