Freezing multiple rows is a simple task, Just select the next row from sheet you want to freeze and go to "View" tab then Freeze pane and click "Freeze panes" option. your desired rows are freezed now and will show through out rolling the entire sheet.
let's take an example.
Suppose we want to freeze 1st 5 rows. We have to just select 6th row from table/sheet and go to "View" tab then Freeze pane and click "Freeze panes" option. 1st five rows are freezes now and will display as a header of all sheet.
let's take an example.
Suppose we want to freeze 1st 5 rows. We have to just select 6th row from table/sheet and go to "View" tab then Freeze pane and click "Freeze panes" option. 1st five rows are freezes now and will display as a header of all sheet.
Very nice sharing, keep it up
ReplyDelete