To freeze top row or column

  1. Go to View -> Freeze Panes -> Freeze first row or first column.

Freeze first row 

  Freeze panes - Basic Formatting

Download and Try using this file:

 
Freeze first column
freeze first column.png
 

Download and Try using this file:


To freeze first 10 rows, 

  1. Select row 11, Go to View -> Freeze Panes -> Freeze panes.

On scrolling, the rows would be fixed.

 

Freeze first 10 rows

freeze first 10 rows.png

Download and Try using this file:

 

  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 8 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .