DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Insert
|
|
|
View
|
|
|
Data
|
|
|
File
|
Detailed explanation-1: -To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Detailed explanation-2: -On the View tab, click Freeze Panes > Freeze Panes.
Detailed explanation-3: -Freeze panes command on the view menu is used to hold row and column titles in place so that they do not scroll when you scroll a worksheet in MS Excel 2007.
Detailed explanation-4: -There are a few different ways to freeze panes in Excel. You can use the Ribbon, the Freeze Panes button on the View tab, or you can use one of the following keyboard shortcuts: Alt + W + F. Alt + V + F.