hi, i hv search the web about splitting and freezing excel pane but could not find a solution to my issue; but i believe this is very common issue and there should be a way to it.
what i like is to split the sheet into 'half' and when i scroll down, only the left part will scroll down and the right side will stay on. as i need to refer to the value on the right side all the time.
pls refer to the attachment for a sample screenshot. the Excel version is 2013
thanks in advance,
There isn't a way to do it on single sheet.
Alternatives are...
1. Have copy of the sheet open using View->New Window.
2. Use modeless userform to display range needed. Refer to link for detail.
https://bettersolutions.com/vba/userforms/modeless.htm
3. Use listbox with some code to adjust position (using .TopLeft property).
Personally, I'd go with option 1.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
hi, we hv tried #1 before posting here but its cumbersome hvto do them each time manually. and about 2 & 3, its too aadvance for us as we hv no idea about macro etc
wonder why MS didn't cretae a solution for this as i believe there are lotsa ppl that need it
thanks for your info and help,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks