RIGHT SIDE FREEZE PANES

[austinandreikurt]

Hi,
Is there a way to FREEZE the right side of your excel then he left side can be moving? Basically, what I am trying to achieve is that the right side, Columns X to AA, is the one having the formula and the left side is where the data will be paste by the user, Columns S to W. The user don't want to set that formula's be in Column A and so on and wants it in Column X. And I want the freezing starts at cell X2 and since the needed formula is in Column X to AA, then I want the moving part to be on the left side. Window split is not an option, I really want to freeze the formula part. Thanks!

 

[mole999]

This might be a way > Column A is on the right side of the spreadsheet !!

 

[pedro-egoli]

mole999, thanks for that was interested in topic as well.
Checkout this site How to Change Worksheet Directon to Right-To-Left in Excel 2013/2016

Once second sheet opens freezing panes works as austinandreikurt require

 

[austinandreikurt]

Ow yes. I know that function before but I have never tried to use it as I can't think of something useful with that. Didn't thought it is a solution that would work for right freeze panes. Hahaha. Thanks alot!