0
- 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.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
To freeze worksheet titles use the button on the tab?
Freeze Panes, View
Is use to place titles on a worksheet?
text
How do you keep the titles and column labels of a worksheet on the screen no matter where the worksheet is scroll?
Go to View Tab; Then go to Windows Group; Click " Freeze Panes"
How do you keep titles and column labels of a worksheet on the screen no matter where the worksheet is scrolled?
Go to View Tab; Then go to Windows Group; Click " Freeze Panes"
What is used to add worksheet column and row titles on a worksheet in excell?
Text
What is used to place titles on worksheet?
Text
What command keeps the titles of a worksheet on the screen no matter where the highlight is moved?
You use the Freeze Panes option to do it. Put the cursor on row below the column headings you want and/or in the column to the right of the of the row headings you want. Then you can apply it. It is usually on the Window menu.
How many panes can you split a large worksheet into on Excel?
You can only have two panes if you use Freeze Panes. If you are using the Split option you can have up to 4 windows on your worksheet.
How do you you keep the titles and columns label of work sheet on the screen no matter where the worksheet is scrolled?
Go to View Tab; Then go to Windows Group; Click " Freeze Panes"
Should Worksheet titles and subtitles be as wordy as possible?
NO
In which ways can you set the row titles to remain visible as you enter the new figures?
*Split the worksheet into 2 vertical panes, w/ the column containing row titles in the first pane *Hide the columns between the first column and the column for November *Freeze the first column
Which of the following displays different sections of a worksheet at the same time in Excel?
It is possible to use Freeze Panes to do it, but the more common way and the correct answer is to use the Split facility.
