austinandreikurt
Board Regular
- Joined
- Aug 25, 2020
- Messages
- 91
- Office Version
- 2016
- Platform
- Windows
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!
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!