If you click on the 15 row header and then use the commands Windows|Freeze
panes, then rows 1-5 will always show as you scroll down to, say, row 100.
To undo this use Windows|Unfreeze
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Ramthebuffs"
wrote in message
...
I have seen spreadsheets where the top rows don't move when you scroll.
How can I do this on my spreadsheet?
Generally its rows 1-15 or something and they are used for summarizing
the data on rows 16-60,000. When you scroll down the top 15 rows
remain, but 16-60,000 scroll.
Thanks in adavance.
--
Ramthebuffs
------------------------------------------------------------------------
Ramthebuffs's Profile:
http://www.excelforum.com/member.php...o&userid=16429
View this thread: http://www.excelforum.com/showthread...hreadid=397881