Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you have the headings scroll down the page as you move dow
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you have the headings scroll down the page as you move dow
hi
i think you might be interested in freeze panes. Place the cellpointer at A2. 2003 and earlier. on the menu barwindowfreeze panes. 2007 view tabwindow groupfreeze 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 |
#3
|
|||
|
|||
Quote:
'Freeze Rows Rows("1:1").Select ActiveWindow.FreezePanes = True ;Freeze Columns Range("A:A").Select ActiveWindow.FreezePanes = True 'Freeze Rows and Columns Range("B2").Select ActiveWindow.FreezePanes = True 'UnFreeze Panes ActiveWindow.FreezePanes = False all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop the headings moving when I scroll down? | Excel Worksheet Functions | |||
Column Headings Scroll out of view | Excel Discussion (Misc queries) | |||
excel-how to get the spreadsheet to move as I move the scroll tab | Excel Discussion (Misc queries) | |||
When I move scroll bar in excell the contents do not move with it | Excel Discussion (Misc queries) | |||
how to have my titles move down as i scroll down the page | Excel Discussion (Misc queries) |