how do i cross frozen titles without unfreezing

B

Boris

In lotus 123 there is a key to cross over frozen titles. Is there such in
excell?
Thanks
Boris
 
D

Dave Peterson

Maybe...

What does "cross over frozen titles" mean (from a person who doesn't use 123).
 
R

RagDyer

If you're referring to XL's "Freeze Panes", you can simply use the arrow
keys to navigate to any of the "hidden" (frozen) cells.
You could also hit <F5> and "goto" any of those cells.

The only problem with that is, the *sheet won't go there*.

You can read the cells contents in the formula bar.
You can even enter and/or revise data and formulas.
But since you're only viewing the formula bar, if the cell contains
formulas, all you can see are the formulas, *not* the returns of the
formulas.
And if they contain numeric data, you will of course see that data
completely *unformatted*.

Is this what you're talking about?
 
Top