ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i cross frozen titles without unfreezing (https://www.excelbanter.com/excel-discussion-misc-queries/39332-how-do-i-cross-frozen-titles-without-unfreezing.html)

Boris

how do i cross frozen titles without unfreezing
 
In lotus 123 there is a key to cross over frozen titles. Is there such in
excell?
Thanks
Boris

Dave Peterson

Maybe...

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



Boris wrote:

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


--

Dave Peterson

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?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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




All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com