Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print different row titles in one sheet w/ many pages | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
How do I get both horizontal and vertical frozen panes in Excell | Excel Discussion (Misc queries) | |||
"print column titles" | Excel Discussion (Misc queries) | |||
print titles won't appear on some pages | Excel Discussion (Misc queries) |