0
Is it freeze panes that allows you to view two areas of your worksheet at the same time?
Wiki User
∙ 6y agoWant this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Where can you find the horizontal split bar on Microsoft Word screen?
It allows you to split the window into two separate panes, aligned horizontally. This allows you to see two different areas of the worksheet at the same time. It can be accessed from the menus or dragged on and off the worksheet from the end of the scrollbar.
To freeze worksheet titles use the button on the tab?
Freeze Panes, View
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.
What does Excel freeze panes options do?
In Microsoft Excel, the Freeze Panes option keeps specific rows or columns visible while scrolling. It creates a separate worksheet area of visible from non-visible areas when scrolled.
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 feature of excel 2010 keeps a portion of a worksheet visible while the other portion scrolls?
Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.
What cell do you activate to freeze rows 1 - 5 in an Excel worksheet?
You would make cell A6 the active cell and then activate the freeze panes option.
What do you use to freeze worksheet titles?
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.
What is an Excel pane?
An Excel pane is part of the window. The worksheet itself can be split into panes using the Split option. You can also freeze panes, so that one is on the screen all of the time. You also have the task pane, which is outside the worksheet, but can show other things, such as help options.
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"
How do you freeze the top row of the current worksheet?
In Excel 2003 and earlier, place your cursor in row 2 and click on Freeze Panes. The Freeze Pains command will freeze the rows above the cursor. Excel 2007 offers an option to freeze top row no matter where your cursor is located.
