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 |
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 |
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