Hi !
I can freeze (from scrolling) the 1st column and the 1st row, but how to do the same with any number of them ?
I do not see this option at Excel 2007.
Please help !
Thank you !
Gary.
Hi Gary,
What do you mean by "any number of them"?
Do you mean not just column A and row 1?
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
i think you you are talking about "freeze pane option"????
click on the CELL (not column header or row header) say cell H10 then on the View menu click "freeze panes"
Column H up to row 10 will stop from scrolling. hope i'm right.
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks