In the attached image I would like the blue box to always be on screen no matter how far down or over I go in the orange box. Currently I have frozen a row so it works scrolling down but not across.
If you have a better suggestion for arrangement please let me know.
Problem.jpg
Hi Architect,
Please see the attached file and let me know if this solve your purpose..
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
Architect you can freeze all rows (for instance) from row 5 upwards, and all columns from column E to A, or from both E5 up and left, but those locked rows/columns will always stay on the screen.
From the looks of it, you want to lock from a certain row upwards, but then only have the columns of those rows locked, but not the columns below those locked rows, locked?
If that is what you want, then it cannot be done. excel works in blocks/ranges or rows and columns, and you cannot break parts of those ranges apart and leave the rest unchanged
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That will do, thank you!
Hi Architect,
Glad the provided solutions worked for you. Please take few seconds to mark this thread as SOLVED and say thanks to the user by adding "Add Reputation".
Thanks in advance!
You were offered 2 different suggestions, which 1 worked for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks