G Guest Sep 6, 2007 #1 How can I fix the header on the top. When i scroll the data down, i dotn' want the header to disappear! Thank you so much! ! !
How can I fix the header on the top. When i scroll the data down, i dotn' want the header to disappear! Thank you so much! ! !
G Guest Sep 6, 2007 #2 Try Menu - View - Freeze Panes. Other option is to use Split if you want to view diff sections of your worksheet at the same time.
Try Menu - View - Freeze Panes. Other option is to use Split if you want to view diff sections of your worksheet at the same time.
M MartinW Sep 6, 2007 #3 Hi Ali, Go to Window>Freeze Panes Where it freezes is decided by the active cell. Everything above and to the left of the active cell will be frozen. e.g. if C3 is the active cell, rows 1 & 2 and columns A & B will be frozen. HTH Martin
Hi Ali, Go to Window>Freeze Panes Where it freezes is decided by the active cell. Everything above and to the left of the active cell will be frozen. e.g. if C3 is the active cell, rows 1 & 2 and columns A & B will be frozen. HTH Martin
