Hi
I have a large worksheet with a frozen colum in the middle, and I need to be able to scroll horizontally on both sides. I cant figure out how to do this. I know I can split screens instead, but the doesn't relly solve my problem since I do not want information to appear multiple times, as it will when i split screens.. So what to do? Thanks so much for any help I can get. I'm stuck..
/Marie
Freeze panes will only freeze columns above, or to the left, or above AND to the left of a given cell.
You cannot have multiple frozen panes.
Effectively, freeze panes allows you to have reference cells above and to the left of your variable data.
AFAIAA, you cannot do what you are asking.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks & damn.. do you have any ideas to how i might then get: A 'fixed' column in the middle and scolling on each side?
thansk again!
/Marie
Sorry. I can't think of a way.
Perhaps you can provide a sample workbook with some typical data and indicate what you want/need to achieve. Might help someone come up with some ideas.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks