how do you have the headings scroll down the page as you move dow
in [Functions]
|
Prev: Auto saving sheets from a workbook as separate files.
Next: How do I auto Expand a cell for printing only?
From: Donna B Donna on 15 May 2010 22:40 How do you have the column headings scroll with you as you work downward on a page ?? Help . . . Bless you for information - much needed ! Thanks
From: FSt1 on 15 May 2010 22:51
hi i think you might be interested in freeze panes. Place the cellpointer at A2. 2003 and earlier. on the menu bar>window>freeze panes. 2007 view tab>window group>freeze panes the above position will freeze row1. if you have more than 1 row for headers, move the cellpointer down all rows above the cellpointer will freeze. you can also freeze columns by placing the cellpointer at b2( or where ever). all columns to the left of the cell pointer wil freeze. regards FSt1 "Donna B" wrote: > How do you have the column headings scroll with you as you work downward on a > page ?? Help . . . Bless you for information - much needed ! Thanks |