Freeze panes

Last updated at April 16, 2024 by

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 panes.xls
 
Freeze first column
freeze first column.png
 

Download and Try using this file:

freeze panes.xls

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:

freeze panes.xls

 

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.