Thread
:
NEED HELP ASAP PLEASE!!
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
NEED HELP ASAP PLEASE!!
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett