Larry, as you can see in the post directly below this one, I have done it! I was doing the adaptations in an Experimental spread with the Lichello Price Table
10 8 5 4 5 8 10 8 5. . . . Test Series
when you posted the additional explanations. Thanks for your efforts! When you come to visit Holland I invite you to a Dinner @ Goucho's.
Also I have protected the same set of rows so that I can not accidentally change the cell content. . .if accidentally would change the contents then I would no longer know what the value was.
This is also a process of No Return: Frozen=Frozen for good but that is no problem. . I could always copy the formulas that are not frozen.
The irony of all this is that on a previous occasion I had already discovered that process by pasting the cells in Word and copying & pasting then back in Excel, but I failed to find that it could be done in Excel simply by using the Special Paste function!
Now if you want to hide them you can also do that but that's another story.
Yes, in the meantime I have discovered various other possibilities too. In 5 years time I will be an Excel Expert
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.