Freeze half the page Verticaly

Hi wolverineandrew,

I believe you are using right to left view of excel.. Just select the column and press Alt + W+ F key combination and see if this is done. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Go to Windows -> freeze options and check there.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Here is my page. i need that right section to stay there as im able to scroll through the left part. Help1.xlsx

Hi wolverineandrew,

See the attached workbook... and let me know if this works for you. thanks.

Help1.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

Not quite, i was able to do that. But it freezes part of the left side which i cant have. I just need the right portion frozen only.

hi wolverineandrew,

you have the default layout of Excel which is left to right... and hence you can freeze the window as I shown
I am not sure if there is any other way. Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

There may be a cleaner method, but this seems to achieve your goal.
1) Not sure where it is on 2003, but you want to find 'New Window'. This will make a duplicate of the spreadsheet you are working on and ensure any changes to one will appear in the other window
2) If you are in 'full screen' mode of excel, you need to get into the mode where each workbook is its own window. Usually, this is achieved by hitting the 'Restore Window' button on the top left of the workbook window (Usually just below the 'X" close Excel button on the top right of the Excel window).
3) Now you can position the windows however you see fit.