Re: Method to select multiple columns:rows in Calc
At 15:32 11/09/2018 -0400, Vince Bonly wrote: I have a Calc sheet in which unwanted background fill color is displayed. The range begins B1307 and C1307 and seems to go the end (wherever that is). Can anyone suggest an easier method than using the mouse to scroll to the "end" starting from B1307:C? Is there an specific keystroke to jump to the end of a selected column? At 15:41 11/09/2018 -0400, Vince Bonly wrote: I have data within the above cells in which the background color is desired. Is there a jump-to keystroke that gets me to the very last row? Three techniques: 1. o Highlight B1307. o Press Ctrl+Shift+End. This will select the region from B1307 to the bottom right *occupied* cell of your sheet. If that selects only columns B and C you can now remove the background. If there is material in later columns, hold down Shift and press left-arrow repeatedly to reduce the selection to columns B and C. Now remove the background. *But*, you will scream, that doesn't get to the bottom, only to the lowest used part of the sheet. But that doesn't matter, as when you print the material nothing below that last used part will print (unless you have perversely set a print range to make it print). So the remaining cells with background are no problem. 2. Alternatively, in the Name Box (to the left of the Input Line), enter: B1307:C1048576 and press Enter. You now have the required range selected. Remove the background. 3. Depending on what backgrounds you have in earlier rows that you do want, it might be easier to remove the background from the whole of columns B and C and reset it in those cells or ranges where you require it. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Method to select multiple columns:rows in Calc
On Tue, Sep 11, 2018 at 2:41 PM WA.TWORSX via AOL wrote: > > > > On 9/11/2018 3:36 PM, Wade Smart wrote: > > On Tue, Sep 11, 2018 at 2:35 PM Vince@GMAIL wrote: > >> > >> I have a Calc sheet in which unwanted background fill color is > >> displayed. The range begins B1307 and C1307 and seems to go the the end > >> (wherever that is). Can anyone suggest an easier method than using the > >> mouse to scroll to the "end" starting from B1307:C? > >> > >> Is there an specific keystroke to jump to the end of a selected column? > >> > >> > >> Using Windows10-64 desktop and AOO-Calc 4.1.5. > > How about just click the Column B and C at the top? > > > > No; I have data within the above cells in which the background color is > desired. > > Is there a jump-to keystroke that gets me to the very last row? Uh.. are commenting on the other post or do you have the same problem? Or, are you using two email addresses? As far as Im aware, there is no keystroke because - how would it know where the end is. You can click in the first cell and then while holding shift hit the down page key and it will make larger jumps. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Method to select multiple columns:rows in Calc
On 9/11/2018 3:36 PM, Wade Smart wrote: On Tue, Sep 11, 2018 at 2:35 PM Vince@GMAIL wrote: I have a Calc sheet in which unwanted background fill color is displayed. The range begins B1307 and C1307 and seems to go the the end (wherever that is). Can anyone suggest an easier method than using the mouse to scroll to the "end" starting from B1307:C? Is there an specific keystroke to jump to the end of a selected column? Using Windows10-64 desktop and AOO-Calc 4.1.5. How about just click the Column B and C at the top? No; I have data within the above cells in which the background color is desired. Is there a jump-to keystroke that gets me to the very last row? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Method to select multiple columns:rows in Calc
On Tue, Sep 11, 2018 at 2:35 PM Vince@GMAIL wrote: > > > I have a Calc sheet in which unwanted background fill color is > displayed. The range begins B1307 and C1307 and seems to go the the end > (wherever that is). Can anyone suggest an easier method than using the > mouse to scroll to the "end" starting from B1307:C? > > Is there an specific keystroke to jump to the end of a selected column? > > > Using Windows10-64 desktop and AOO-Calc 4.1.5. How about just click the Column B and C at the top? -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Method to select multiple columns:rows in Calc
I have a Calc sheet in which unwanted background fill color is displayed. The range begins B1307 and C1307 and seems to go the the end (wherever that is). Can anyone suggest an easier method than using the mouse to scroll to the "end" starting from B1307:C? Is there an specific keystroke to jump to the end of a selected column? Using Windows10-64 desktop and AOO-Calc 4.1.5.
Speakers needed for Apache DC Roadshow
We need your help to make the Apache Washington DC Roadshow on Dec 4th a success. What do we need most? Speakers! We're bringing a unique DC flavor to this event by mixing Open Source Software with talks about Apache projects as well as OSS CyberSecurity, OSS in Government and and OSS Career advice. Please take a look at: http://www.apachecon.com/usroadshow18/ (Note: You are receiving this message because you are subscribed to one or more mailing lists at The Apache Software Foundation.) Rich, for the ApacheCon Planners -- rbo...@apache.org http://apachecon.com @ApacheCon - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Speakers needed for Apache DC Roadshow
We need your help to make the Apache Washington DC Roadshow on Dec 4th a success. What do we need most? Speakers! We're bringing a unique DC flavor to this event by mixing Open Source Software with talks about Apache projects as well as OSS CyberSecurity, OSS in Government and and OSS Career advice. Please take a look at: http://www.apachecon.com/usroadshow18/ (Note: You are receiving this message because you are subscribed to one or more mailing lists at The Apache Software Foundation.) Rich, for the ApacheCon Planners -- rbo...@apache.org http://apachecon.com @ApacheCon - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: Hunspell Spellchecker
At 18:26 11/09/2018 +1000, Ron Clough wrote: I am using AOO 4.1.5 on Windows 8.1 I'll be grateful to be told how to install Hunspell Spellchecker. In following up a particular issue, the advice given was to go to Writing Aids and ensure Hunspell Spellchecker is ticked, However, it didn't appear in the drop-down list. Where are you looking? If you are seeing a drop-down list, I think you must be looking in the wrong place! Go to Tools | Options... | Language Settings | Writing Aids | Available language modules. You should see Hunspell SpellChecker there. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Hunspell Spellchecker
On Tue, 11 Sep 2018 18:26:37 +1000 Ron Clough wrote: > I am using AOO 4.1.5 on Windows 8.1 > > I'll be grateful to be told how to install Hunspell Spellchecker. In > following up a particular issue, the advice given was to go to Writing Aids > and ensure Hunspell Spellchecker is ticked, However, it didn't appear in > the drop-down list. > > Thankyou > > Ron It is the first item on the list. Sometimes lists open in the middle; you may have to scroll the list up to see it. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org