Hi. I am currrently in the Royal Navy an with all its spending power we are
still running Excel 2000. What I am trying to do is, I want to keep rows 1
& 2 stationary when i scroll down. This is due to the fact that I have a lot
of customers in column A. I also have a list of stock going fom A to FE.
So when I scroll down to find a customerr in row 312 for example. I need to
know what column the entry is to be inputed into instead of press ing pge up
all the time.

E.G.

Rows 3 - 300 are customer names
Columns A -FE are different stock

In rows 1 and 2 I have stock information. When I have to input data for
customer on row 200. i have to page up to see what product i am on. How do
I get rows 1 & 2 to stay staionary when I scroll down.

Your help in this matter will be most appreciated.

Dragon Blood

Dragon Blood

Select A3 and goto WindowFreeze Panes"

Mike Rogers

"Dragon Blood" wrote:

Hi. I am currrently in the Royal Navy an with all its spending power we are
still running Excel 2000. What I am trying to do is, I want to keep rows 1
& 2 stationary when i scroll down. This is due to the fact that I have a lot
of customers in column A. I also have a list of stock going fom A to FE.
So when I scroll down to find a customerr in row 312 for example. I need to
know what column the entry is to be inputed into instead of press ing pge up
all the time.

E.G.

Rows 3 - 300 are customer names
Columns A -FE are different stock

In rows 1 and 2 I have stock information. When I have to input data for
customer on row 200. i have to page up to see what product i am on. How do
I get rows 1 & 2 to stay staionary when I scroll down.

Your help in this matter will be most appreciated.

Dragon Blood

Pretty basic. Place your cursor in cell a3window (on the toolbar) freeze
panes

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dragon Blood" <Dragon wrote in message
...
Hi. I am currrently in the Royal Navy an with all its spending power we
are
still running Excel 2000. What I am trying to do is, I want to keep rows
1
& 2 stationary when i scroll down. This is due to the fact that I have a
lot
of customers in column A. I also have a list of stock going fom A to FE.
So when I scroll down to find a customerr in row 312 for example. I need
to
know what column the entry is to be inputed into instead of press ing pge
up
all the time.

E.G.

Rows 3 - 300 are customer names
Columns A -FE are different stock

In rows 1 and 2 I have stock information. When I have to input data for
customer on row 200. i have to page up to see what product i am on. How
do
I get rows 1 & 2 to stay staionary when I scroll down.

Your help in this matter will be most appreciated.

Dragon Blood

This may work. I use Excel 2007. If I remember correctly for Excel 2000,
select cell A3. Then Window/Freeze panes. This will cause rows 1 and 2 not
to scroll.

Tyro

"Dragon Blood" <Dragon wrote in message
...
Hi. I am currrently in the Royal Navy an with all its spending power we
are
still running Excel 2000. What I am trying to do is, I want to keep rows
1
& 2 stationary when i scroll down. This is due to the fact that I have a
lot
of customers in column A. I also have a list of stock going fom A to FE.
So when I scroll down to find a customerr in row 312 for example. I need
to
know what column the entry is to be inputed into instead of press ing pge
up
all the time.

E.G.

Rows 3 - 300 are customer names
Columns A -FE are different stock

In rows 1 and 2 I have stock information. When I have to input data for
customer on row 200. i have to page up to see what product i am on. How
do
I get rows 1 & 2 to stay staionary when I scroll down.

Your help in this matter will be most appreciated.

Dragon Blood

Hi. I am currrently in the Royal Navy an with all its spending power we
are
still running Excel 2000.

Others have answered your question but I'm glad to see that the Royal Navy
is husbanding my taxes well. <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dragon Blood" <Dragon wrote in message
...
Hi. I am currrently in the Royal Navy an with all its spending power we
are
still running Excel 2000. What I am trying to do is, I want to keep rows
1
& 2 stationary when i scroll down. This is due to the fact that I have a
lot
of customers in column A. I also have a list of stock going fom A to FE.
So when I scroll down to find a customerr in row 312 for example. I need
to
know what column the entry is to be inputed into instead of press ing pge
up
all the time.

E.G.

Rows 3 - 300 are customer names
Columns A -FE are different stock

In rows 1 and 2 I have stock information. When I have to input data for
customer on row 200. i have to page up to see what product i am on. How
do
I get rows 1 & 2 to stay staionary when I scroll down.

Your help in this matter will be most appreciated.

Dragon Blood

I concur - no need to apologize for Excel 2000. A very solid product, one
you can rely on to provide accurate results very quickly. Newer does NOT
always mean better, especially when newer is built by the lowest bidder.

Yours Respectfully,
from the (ex)Colonies

"Sandy Mann" wrote:

Hi. I am currrently in the Royal Navy an with all its spending power we
are
still running Excel 2000.

Others have answered your question but I'm glad to see that the Royal Navy
is husbanding my taxes well. <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dragon Blood" <Dragon wrote in message
...
Hi. I am currrently in the Royal Navy an with all its spending power we
are
still running Excel 2000. What I am trying to do is, I want to keep rows
1
& 2 stationary when i scroll down. This is due to the fact that I have a
lot
of customers in column A. I also have a list of stock going fom A to FE.
So when I scroll down to find a customerr in row 312 for example. I need
to
know what column the entry is to be inputed into instead of press ing pge
up
all the time.

E.G.

Rows 3 - 300 are customer names
Columns A -FE are different stock

In rows 1 and 2 I have stock information. When I have to input data for
customer on row 200. i have to page up to see what product i am on. How
do
I get rows 1 & 2 to stay staionary when I scroll down.

Your help in this matter will be most appreciated.

Dragon Blood

Thank you all for your help. That has saved me hours of being stressed.
Again thanks.


"Dragon Blood" wrote:

Hi. I am currrently in the Royal Navy an with all its spending power we are
still running Excel 2000. What I am trying to do is, I want to keep rows 1
& 2 stationary when i scroll down. This is due to the fact that I have a lot
of customers in column A. I also have a list of stock going fom A to FE.
So when I scroll down to find a customerr in row 312 for example. I need to
know what column the entry is to be inputed into instead of press ing pge up
all the time.

E.G.

Rows 3 - 300 are customer names
Columns A -FE are different stock

In rows 1 and 2 I have stock information. When I have to input data for
customer on row 200. i have to page up to see what product i am on. How do
I get rows 1 & 2 to stay staionary when I scroll down.

Your help in this matter will be most appreciated.

Dragon Blood

Dragon Blood

Glad it helped, thanks for the post back!

Mike Rogers

"Dragon Blood" wrote:

Thank you all for your help. That has saved me hours of being stressed.
Again thanks.


"Dragon Blood" wrote:

Hi. I am currrently in the Royal Navy an with all its spending power we are
still running Excel 2000. What I am trying to do is, I want to keep rows 1
& 2 stationary when i scroll down. This is due to the fact that I have a lot
of customers in column A. I also have a list of stock going fom A to FE.
So when I scroll down to find a customerr in row 312 for example. I need to
know what column the entry is to be inputed into instead of press ing pge up
all the time.

E.G.

Rows 3 - 300 are customer names
Columns A -FE are different stock

In rows 1 and 2 I have stock information. When I have to input data for
customer on row 200. i have to page up to see what product i am on. How do
I get rows 1 & 2 to stay staionary when I scroll down.

Your help in this matter will be most appreciated.

Dragon Blood