selective freeze panes excel

There might be an easier way of doing this but

I have an excel sheet with columns A and B frozen so they are visible when scroll right.

I have a text in row 1 merged across columns A to Z.

The document spans columns A to BZ

I would like the header text in row 1, the document title, to remain visible when scrolling to the right, i have tried putting it in a text box and selecting do not move with cells option but that doesn't seem to work either.

Is my question understandable? I can upload an excel sheet to demonstrate if wanted. Any help would be greatly appreciated.

Thanks Ed.
edmaceyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris BottomleySoftware Quality Lead EngineerCommented:
If I understand correctly then unfreeze the panes and select cell B2, now freeze panes again .. try scrolling and is that what you want?

Chris
0
edmaceyAuthor Commented:
Dear Chris, I have attached an example excel sheet for demonstration. Ed.
demonstrationforexpertsexchange.xls
0
Chris BottomleySoftware Quality Lead EngineerCommented:
What do you want ... column a throug J to remain in view as well as row 1?

Chris
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

edmaceyAuthor Commented:
So just row 1, from column a to j to remain in view, or actually just that text to remain in view, in whatever way that is achievable. Ed.
0
Chris BottomleySoftware Quality Lead EngineerCommented:
Ah

I begin to understand.  I don't believe you can do that but I need to look further to validate that theory and try some alternatives.

Maybe someone else will have an answer in the meantime but I will respond later otherwise.

Chris
0
edmaceyAuthor Commented:
Cheers Chris, I await your response, hopefully it will be positive. Ed.
0
Chris BottomleySoftware Quality Lead EngineerCommented:
Sorry

Everything I try fails, I didn't think it possible and I haven't been able to 'picture' a work-around either.

Chris
0
edmaceyAuthor Commented:
Chris, just before I close this. Is there anyway to anchor a picture in excel so it doesn't move during freeze frame move. Thanks Ed.
0
Chris BottomleySoftware Quality Lead EngineerCommented:
edmacey

Sorry but not to my knowledge.  It might be possible to relocate it during a freeze frame move to appear stable, but I wouldn't want to try and do so myself.

Chris
0
TiranDagan55Commented:
Here's a different way to acheive what you are trying to do without freezing panes. Just use a form scrollbar
Scroll-Without-Freeze-Pane.xls
0
edmaceyAuthor Commented:
Dear Tiran,

This works great, really well, except is there a way for the information in the scrolled area not to be part of a different sheet, as it will be this information which will be edited. It could be edited from the other sheet, but my whole focus for trying to find the freezing not freezing certain bits was to make the input area look more attractive to the user.

Ed.
0
TiranDagan55Commented:
The whole effect of scrolling is really a trick. It relies on the cell formulas to display the information you want in a scrollable fashion. You can either place it elsewhere in the same spreadsheet or another idea is to lay them in rows and modify the formulas to transpose but it would really complicate your solution a lot. I would say your best bet (if you stay with this solution) is to have an easy to edit worksheet vs easy to view sheet. Otherwise you are back to relying on frozen panes etc which introduce a lot of other issues down the road.
0
Saqib Husain, SyedEngineerCommented:
another workaround is to use the statusbar to display the text by putting this macro in the workbook module

Private Sub Workbook_Open()
Application.StatusBar = Range("A1")
End Sub


Ofcourse you would lose the functionality of the status bar.

Saqib
0
Saqib Husain, SyedEngineerCommented:
Here is another workaround which I used to enjoy sometime ago. Not very elegant but it served the purpose.

Whenever the title  scrolls out you have to click on a cell to activate the selection_change event.

Saqib
demonstrationforexpertsexchange-.xls
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
edmaceyAuthor Commented:
I'm sure that this is achievable so please can you keep this open for the moment.
0
Saqib Husain, SyedEngineerCommented:
Ed,

What are your comments on my proposal?

Saqib
0
edmaceyAuthor Commented:
This doesn't achieve what was asked in the question but does offer a work around. It isn't the one i wanted but I think that that is unachievable. Many thanks ssaqibh. Ed.
0
Saqib Husain, SyedEngineerCommented:
Why did you grade this as "B" without commenting on it?
0
edmaceyAuthor Commented:
I did comment on it, see author comments:
This doesn't achieve what was asked in the question but does offer a work around. It isn't the one i wanted but I think that that is unachievable. Many thanks ssaqibh. Ed.
0
Saqib Husain, SyedEngineerCommented:
Sorry, my mistake. Did not see it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.