W wavetoall Nov 5, 2005 #1 How do you make the heading of columns stay their while you scroll the rest of information up and down?
How do you make the heading of columns stay their while you scroll the rest of information up and down?
B Bernard Liengme Nov 5, 2005 #3 Click on the row header 2 (left side of worksheet) Use Windows|Freeze Panes Now when you do vertical scroll row 1 is always visible best wishes
Click on the row header 2 (left side of worksheet) Use Windows|Freeze Panes Now when you do vertical scroll row 1 is always visible best wishes
B Biff Nov 5, 2005 #4 Hi! If your headers are in row 1, starting in cell A1.... Select cell A2 Goto Window>Freeze Panes Biff
Hi! If your headers are in row 1, starting in cell A1.... Select cell A2 Goto Window>Freeze Panes Biff
W wavetoall Nov 7, 2005 #5 Thanks to all for the response and helping me. I have another question, can one make the first row be zero or nothing so that the second row is one?
Thanks to all for the response and helping me. I have another question, can one make the first row be zero or nothing so that the second row is one?
