Freezing Rows & Columns (Help wanted)
Hi,
Needed help with freezing rows and columns.
So in the file I have already frozen TILL Row 6. Which is okay. But the problem is I need column AF to stay fixed as well.
For example when i scroll down only A6 to AE6 should scroll down while the column AF stays fixed and the cells in AF do not scroll down as well along with the rest.
Any help will be highly appreciated. I had gotten help from this place before and it's great.
File is attached.
Thanks in advance!Freezing Rows & Columns.xlsx
If I understand you, you want the columns/rows to the LEFT of AF to move, but AF to remain fixed? Sort of like a reversed "fix titles"?
Not sure this is possible, but another option might be to use a split screen, so that you have most of your columns showing on the left and AF showing on the right "window. To do this, remove Titles, and you will see, to the right of the bottom scrll-bar, and small tab, click and hold that, and drag it to the left
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
I want AF column to be frozen but at the same time but also want A1 to AE6 frozen at the same time. So everything below A6-AE6 should scroll.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks