At 22:46 11/02/2018 -0700, Nobody Noname wrote:
I need to select large cell diapason [= "range"] C2:C150240 to
insert formula. I did not found how to do this.
This is not really a question about LibreOffice but how you use a
computer or spreadsheet more generally. There are various techniques
you could use. (But you do not mention your operating system, which
may make a difference.) Try one of these:
o Highlight cell C2. Scroll down to row 150240. Hold down Shift while
you click on cell C150240.
o Is row 150240 the last row containing any entry in column C? If so,
first highlight cell C2 and then press Ctrl+Shift+down-arrow.
o Is row 150240 the last row containing any entry? If so, first
highlight cell C2 and then press Ctrl+Shift+PageDown. If this causes
the selection to include rows to the right of C, hold down Shift and
use left-arrow to reduce the selection to a single column.
o Give your required range a name. To do this, highlight cell C2 and
go to Insert | Names > | Define... . In the Name box, enter a name.
The "Assigned to" box will show something like "$Sheet1.$C$2". Modify
this to read "$Sheet1.$C$2:$C$150240" (without the quotation marks).
Click OK. Your required range now has a name. To select the range,
click the down-arrow to the right of the Name box (at the left of the
Input Line) and select your new name from the drop-down menu.
I trust this helps.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] Need to select large diapason · Brian Barker
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy