Prev: How do I import data into Excel from Bloomberg using Excel 2007?
Next: Sort Worksheets
From: jls3 on 19 Mar 2010 00:00
From the Microsoft Quick Reference Card at:

http://office.microsoft.com/training/Training.aspx?AssetID=RP011212271033&CTT=6&Origin=RC011212161033

Freeze panes
Keep titles in sight as you scroll through worksheets. To freeze titles,
make a selection in the worksheet, and then click Freeze Panes on the Windows
menu.

To freeze titles, do not select the titles themselves. To freeze:

Column titles only Select the first row below the titles.
Row titles only Select the first column to the right.
Both column and row titles Select the cell that is both directly below the
column titles and to the right of the row titles.
To unfreeze panes, on the Window menu, click Unfreeze Panes.

Tip You can freeze panes anywhere, not just below the first row or to the
right of the first column. Click the row below, or the column to the right,
or the cell that is both below and just to the right of whatever information
you want to freeze.



"emilyp" wrote:

> I've tried highlighting the row I would like to freeze, usually just the
> first row, but it always freezes it after the 16th row. Any suggestions!?
> This is really frustrating!
 | 
Pages: 1
Prev: How do I import data into Excel from Bloomberg using Excel 2007?
Next: Sort Worksheets