Check sibling questions

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:

 

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.