Re: [users] Calc - freezing rows and text on menus
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
Re: [users] Calc - freezing rows and text on menus
AG wrote: 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? 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 Yes. To freeze Row 1 and Column A, select (click in) cell B2. The select Window Freeze. The general case: everything above and to the left of the cell you've selected will be frozen. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 23/10/10 20:01, Richard Detwiler wrote: AG wrote: 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? 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 Yes. To freeze Row 1 and Column A, select (click in) cell B2. The select Window Freeze. The general case: everything above and to the left of the cell you've selected will be frozen. Nice one! Thanks Richard. AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On Thursday 07 October 2010 06:22, 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? It is the tip of the arrow that does the work*. You only need this tip on your menu item to see the tooltip bubble. The tooltip position is set by the Operating System and is usually bottom right of the pointer arrow when the pointer is top left where the toolbars normally sit. Finetune your pointer placement if you wish to read the menus is the best answer. * the single pixel at the tip of the arrow is a hotspot which is where the actual click happens. On the text I-beam pointer this hotspot is midway up the I HTH -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On Thursday 07 October 2010 06:22, 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? It is the tip of the arrow that does the work*. You only need this tip on your menu item to see the tooltip bubble. The tooltip position is set by the Operating System and is usually bottom right of the pointer arrow when the pointer is top left where the toolbars normally sit. Finetune your pointer placement if you wish to read the menus is the best answer. * the single pixel at the tip of the arrow is a hotspot which is where the actual click happens. On the text I-beam pointer this hotspot is midway up the I HTH -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc - freezing rows and text on menus
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 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
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) Sorry, I cannot help you with the yellow bubbles. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On Wed Oct 06 2010 10:22:48 GMT-0700 (PDT) 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? On the top of the scroll bar, just above the up arrow, you should see a dark line. Place the mouse pointer on this and the pointer changes to a double headed arrow. Right click and hold to move where you want the separation. For columns the line in on the right end of the lower scroll bar. (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? There is no way to reposition the help pop-up. You can turn off the tips, Tools Options OpenOffice.org General . At the top select/deselect Tips. HTH - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 2010-10-06 1:34 PM, JOE Conner wrote: 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) Interesting, didn't know you could do it this way. Thanks! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
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) Sorry, I cannot help you with the yellow bubbles. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Thanks Joe, that's useful to know as a shortcut. AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 06/10/10 18:36, RA Brown wrote: On Wed Oct 06 2010 10:22:48 GMT-0700 (PDT) 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? On the top of the scroll bar, just above the up arrow, you should see a dark line. Place the mouse pointer on this and the pointer changes to a double headed arrow. Right click and hold to move where you want the separation. For columns the line in on the right end of the lower scroll bar. Wasn't aware of that as an option. Thanks for pointing that out. (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? There is no way to reposition the help pop-up. You can turn off the tips, Tools Options OpenOffice.org General . At the top select/deselect Tips. Unfortunately that kind of defeats the object. I want the pop ups because they do help explain the menu option. I just don't want the little buggers obscuring the actual menu items. I've tried dragging them off to the side and it just doesn't work, so I was curious as to whether or not there was an option to reposition them. Oh well. HTH It did, thanks. AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 06/10/10 18:40, Tanstaafl wrote: On 2010-10-06 1:34 PM, JOE Conner wrote: 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) Interesting, didn't know you could do it this way. Thanks! Fascinating. Something new every day :-) Except on my copy ^F throws up the search and replace dialogue (3.2.0 on ubuntu 10.04) But there's an alternative. At the top of the vertical scroll bar there's a thick line. Grab this and drag down to split the screen into two independently scrollable regions. Similarly for the horizontal scroll. This too can effectively freeze part of the display. (I see now that window|freeze and window|split are mutually exclusive menu options.) -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On Thursday 07 October 2010 07:09, Mike Scott wrote: On 06/10/10 18:40, Tanstaafl wrote: On 2010-10-06 1:34 PM, JOE Conner wrote: 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) Interesting, didn't know you could do it this way. Thanks! Fascinating. Something new every day :-) Except on my copy ^F throws up the search and replace dialogue (3.2.0 on ubuntu 10.04) You are right [Ctrl]+[F] is find. [Alt] [W] [F] is the correct keyboard shortcut for this. Alt is not held like a shift key here. These three keys are tapped one at a time. All menu options are available via the Alt key and the underlined letters. My favourite on a hundred+ page thesis is Dutch Elm disease - [Alt] [E] [L] [M]. Though on some versions of OO.o it was the eating disorder - [Alt] [E] [A] [T]. Of course after the screams settle down [Ctrl]+[Z] fixes things. But there's an alternative. At the top of the vertical scroll bar there's a thick line. Grab this and drag down to split the screen into two independently scrollable regions. Similarly for the horizontal scroll. This too can effectively freeze part of the display. (I see now that window|freeze and window|split are mutually exclusive menu options.) Ooh! I learned something new - thanks. -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org