Hi,
Not sure i understand correctly.
-Are you trying to view, for example, 2 non-continuous rows on the same
screen to be able to (e.g.) compare them, or something similar?
In this case, you can split your sheet horizontally into 2 scroll areas:
-select a entire row
-menu Window Split
- If you are trying to view only specific rows based on a criteria, eg all
rows related to the customer id CUST0432 from column A, you could use the
Auto Filter excel featu
- select the data and header
- menu data Filter Auto Filter
On your header row, dropdown should appear in each cell.
- Choose the value you want to filter on from the Customer (or other)
field, say CUST0432.
This will hide any row that doesn't have CUST0432 in it.
Use the 'custom' option from the dropdows to make more complex filters.

I hope this helps,
Regards,
Sébastien
"JavyD" wrote:

How can I have a macro just show certain rows in within a screen. Right now
they way I'm doing it it goes to a cell, but half of the rest of the
information is not visible, then I have to scroll to see the rest, is this
possible?