On 06/10/10 18:34, JOE Conner wrote:
 On 10/6/2010 10:22 AM, AG wrote:
Hello all

Two (unrelated) questions on using Calc:

(1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible?

(2) When mousing over the various menus, the yellow text bubble that explains what the item does conceals the menu items concerned. How can I shift the bubble so that it no longer obscures the menu item it describes?

Thanks for help on both or either of these two issues.

AG
1. Click on the cell below and to the right of the rows and columns you want to freeze.
2.  Click  WINDOW -> FREEZE (or CTRL F)

A further question on this theme:

If I wanted to freeze row 1 as well as column A, is there a way of doing this? From my attempts so far, I can only do a row or a column, but not both together.

It may not possible, and after loads of data I may find that it is not even desirable to do so, but curious minds and the desire to experiment and all that jazz ... ;-)

Cheers

AG


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Reply via email to