LinkBack URL
About LinkBacks
Hello,
In my workbook, I would like to Column A and Rows 1 and 2 so that all are displayed when I move left to right and up and down.
Currently, when I try selecting Column A and the first 2 rows, and then freezing, it doesn't work properly.
Thanks!
Hello,
In my workbook, I would like to Column A and Rows 1 and 2 so that all are displayed when I move left to right and up and down.
Currently, when I try selecting Column A and the first 2 rows, and then freezing, it doesn't work properly.
Thanks!
If you want row 1 and 2 and column A to remain, put the cursor in B3, then freeze panes
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
FYI . . . Freeze Panes uses the top left corner of the active cell to determine which rows & columns to keep in view.Currently, when I try selecting Column A and the first 2 rows, and then freezing, it doesn't work properly.
Columns to the left of the active cell and rows above the active cell will remain in view during scrolling.
If it didn't work properly then you did not have cell B3 selected when applying Freeze Panes.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks