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+unsubscr...@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