1 Starting with a new worksheet, move to cell C4
2 Use the command Windows | Freeze Panes
Now as you scroll thru the worksheet, rows 1, 2 and 3 and columns A and B
remain visible
To undo this, use Windows |Unfreeze panes (with any active cell)
If you use XL 2007: View tab, Windows group, Freeze Panes icon
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Jackie" wrote in message
...
I opened a worksheet once & it had a split in the column and showed the
headers too. I want to learn how to do this to worksheets I work with
from
now on. Do you have any ideas how this can be accomplished? I thought it
was quite handy at the time, and have had trouble figuring it out ever
since.