Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Boris
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
RagDyer
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
print different row titles in one sheet w/ many pages Carman Law Excel Worksheet Functions 2 May 24th 05 12:08 PM
How to group similar column titles together???? vrk1 Excel Discussion (Misc queries) 2 April 30th 05 12:17 AM
How do I get both horizontal and vertical frozen panes in Excell CraigScherer Excel Discussion (Misc queries) 3 April 27th 05 05:22 PM
"print column titles" fe Excel Discussion (Misc queries) 1 November 30th 04 08:12 PM
print titles won't appear on some pages amzy19 Excel Discussion (Misc queries) 1 November 28th 04 11:16 AM


All times are GMT +1. The time now is 06:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"