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:

 

Go Ad-free
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 14 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.