0
If you have a large spreadsheet and scroll down, the upper lines will disappear. If you want a row to stay in place, for example the titles of several columns, you can "freeze" it. So when you scroll down, the uppermost line (for example) will always stay in place. This comes in handy if you have multiple columns.
Wiki User
∙ 13y ago
Wiki User
∙ 13y agoa freeze pan takes selected rows or columns and then freezes them into place.
Add your answer:
Earn +20 pts
What is it when Excel displays titles on screen no matter how far you scroll?
Freeze Pane
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.
What does Excel allow you to do so that it will display titles on the screen no matter how far down you scroll?
The function you are looking for is Freeze Pane, to accomlish this, simply do the following.Excel 2003Go To: Window > Freeze PaneExcel 2007Go To: View > Freeze Pane
What formula makes Excel show the desired cells no matter where you scroll?
There is no formula that does that. It is an option called freezing the pane. In Excel 2007 you can get to the option from the View tab on the menu ribbon in the Window section. Click on Freeze Panes and select the option you want.
Which window contains additional commands in excel?
task pane
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.
What is the difference between freeze pane option in Microsoft Excel 2003 and Microsoft Excel 2007?
In Excel 2003 you would normally position your cursor in the cell to the right of vertical titles and below verical titles. The choose WIndow Freeze Panes. In 2007 choose the View tab and there is a button for Freeze panes on the Window group For Differnces between the versions try http://www.mousetraining.co.uk/ms-office-training-manuals.html. For a interative guide where you select old menu in 2003 it shows you new position in the new version 2007 http://office.microsoft.com/en-us/powerpoint/HA101490761033.aspx?pid=CH100668131033
How do you freeze a line in a document on Microsoft Excel?
this my personal file
How can you print work sheet with Excel task pane on it?
It depends on which task pane is open. There are dozens of task panes -- some will let you get to other commands while they are open, others will not. If you are not able to access any option other than what is in the task pane, then close the open task pane before trying to print.
How do you fix a row as a title in ms Excel?
If you mean you want a whole row just for the title, you could merge the rows to make one box and type in the title. However I think you mean you want to lock the first row on excel so that it stays fixed at the top of MS Excel. This could be done by going to the view ribbon (assuming you are using MS 2007+) and under freeze panes under the windows box (between Arra nge all and the Split/Hide/Unhide options) and click Freeze Pane/top row/first column to suit your needs.
How do you modify a worksheet so the first rows is always visible?
There are two methods to do this: either split the worksheet pane, or freeze the row. To split: if you look on the right side of the pane, next to the column headers (A, B, C, . . .), just above the top scroll arrow, you will see a horizontal bar. You can drag and drop this downwards to open a split screen view. You can also freeze the rows by using the menu option "Freeze Panes". The exact location of "Freeze" on the menu changes in different versions of Excel from the old menus to the new "ribbon" system of versions 2007 and 2010. But look for it - you'll find it! The appearance and behavior of each method is slightly different, so you may want to experiment with both.
What command will lock rows and columns in position on the screen in Excel?
Freeze command
