How to freeze an area in Excel?

Question

I want to freeze only certain cells in an area in an excel sheet to make that area act like a fixed menu. A screenshot is attached as an example. The highlighted area needs to be fixed when a user scrolls vertically.

Thanks for any advice.

Answer 1

Excel has a "Freeze panes" for this, in the "View" menu, "Window" item, as you can see from this screenshot:

You select the cell at the right bottom of the area you want to freeze and you do "freeze panes". There are some more possibilities you can find while clicking "Help" and searching for "freeze".

edit after edit of original question:
Oh. Seeing the edit, I think I believe what you want: you want the left columns to be fixed (you can't scroll down) while you want the other columns to be scrollable. This is not possible, because it would mean that the number of your row does not correspond with the row number of the cell you're in.