Re: [libreoffice-users] Need to select large diapason

On 12/02/18 09:53, Brian Barker wrote:
> 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 like this one. But in my version 5.1.6.2, although the F1 Help gives
the same as you quoted [Insert | Names > | Define ...], the actual offer
in the spreadsheet is slightly different :

Insert | Named Expressions > | Define ...

Philip

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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