Excel - showing just one Excel Record at at time?

How can I show just one record at a time on the screen when using
Microsoft Excel, vsn. 2002

You could hide all the other rows you do not want to see.

Or you could try Data|Form if you are not using too many fields in that row

Or maybe you could create a userform to show the data from the row you want to see.

Take a look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

The source code is available for a small fee ($20 USA, IIRC).  So you can modify
it as much as you want.


--
Dave Peterson