can you lock a section on a spreadsheet to not move while you scro

[big ike]

i am trying to add prices to a spreadsheet without closing off the item
numbers i need to see while i am pricing it. I have tried to hide and unhide
the part i need to see but when i unhide it it is gone.

 

[Paul B]

big ike, try windows freeze panes
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Max]

Perhaps try Window > Split
(or Window > Freeze pane)

For e.g.: Assuming your prices are located
within the top 10 rows, and you need these
rows to remain in view while you work on cells below

Select A11
Click Windows > Split

This'll give you a separately scrollable window
above and below the top 10 rows

To remove the split-line, just double click on it
(or click Wndow > Remove Split)

You can also "move" the split further down / up
to suit by just dragging it

Likewise, you could also do "vertical" splits
to have 2 separately scrollable windows to the left / right
(just select a top cell, say D1, and repeat the steps)

Experiment to taste ..