scrolling "header"?

[Apelcius]

hello all,

i have a list of numbers, with specific devices associated with each number.

see attached spreadsheet.

what i'm trying to do is to:
1) get the shaded area to stay where they are, no matter where i'm scrolling the information
in other words: if i scroll down, i still want [product 1, part number, and color] to stay at the top of the scroll.
2) same thing, but with the left column [levels 1 to end]

so, column 'A' to always be there as i scroll right, and rows 1-2 to always be there as i scroll down, etc while scrolling through the rest of the chart [B3:end]

[TMS]

Put the cursor in the cell with "random stat" and choose Freeze Frames from the View menu.

Regards

[tom1977]

try attachment

[TMS]

@tom1977: what's the point of uploading a sample workbook if you don't explain how you did it?

Regards, TMS

[tom1977]

You have made explanation I have made example so everything is ok

[TMS]

@tom1977: OK, fair enough.

[Apelcius]

thank you both for excellent work here... but slight issue... i don't have "Freeze Frame" option in view tab... or any tab for that matter...

i've attached what i do have in the view tab.

is there another way to get the same thing?

[tom1977]

Sorry I do not use ex 2003

[Apelcius]

Found it!! It's under "Window" tab. Thanks for the help guys!!

[TMS]

In Excel 2003, it's an option in the Window menu.

Regards