Freeze Panes, View
Go to View Tab; Then go to Windows Group; Click " Freeze Panes"
Go to View Tab; Then go to Windows Group; Click " Freeze Panes"
Put your cursor on the row below where you would like to freeze the title row.Select the View tab.In the Window section, click on the Freeze Panesdrop-down menu.Select the freeze option you want: both row and column, rows, or columns.
Column and Row titles are on a worksheet by default. They can be hidden or shown in the View tab of the Options setting. They are not there by default when printed. You can add them in for printing on the Sheet tab options of the Print Setup.
Zoom button on the View Tab
Go to view Tab and click the Zoom button
Go to View Tab; Then go to Windows Group; Click " Freeze Panes"
More Functions Button on the Formulas Tab.
When you click the Insert Worksheet button in Excel, the new worksheet is placed immediately to the right of the currently active worksheet tab. If there are no other worksheets, it will be the first worksheet in the workbook. The new worksheet is typically named "SheetX," where X is the next sequential number.
Zoom
On the View tab, in the Window section.
A worksheet contains columns, rows and cells and is where you do your work. Each worksheet has a name. You can have more than one worksheet in a workbook. Each worksheet has a tab at the bottom of the screen, with its name on it. This is a sheet tab. It allows you to identify the different worksheets and by clicking on a sheet tab, you can change from one worksheet to another.