| || | Novice | || | Beginner | || | Intermediate | || | Advanced | || | Specialist | || | Expert | || |
List of Features
| Filter | Advanced Filter | Pivot Table | Group and Outline | Data Validation | Name Manager | ||||||
| Goal Seek | Freeze Panes | Split Screen | Conditional Formatting | Text to Columns |
Freeze Panes
Freeze Panes
This feature is most appropriate to use when dealing with large sets of data and we have to navigate up and down
It freezes or locks specific Rows or Columns of the worksheet so that they remain visible at all times
You can freeze rows at the top and columns on the left side of the worksheet only.
[Alt]+W+F
This feature is most appropriate to use when dealing with large sets of data and we have to navigate up and down
It freezes or locks specific Rows or Columns of the worksheet so that they remain visible at all times


