8 files changed, 221 insertions, 116 deletions
diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp
index 7473556970..52a29b8dc8 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -262,7 +262,12 @@
 </variable></paragraph>
 <paragraph role="paragraph" id="par_id3154059"><variable id="addinana"><emph>Insert - Function</emph> - Category <emph>Add-In</emph>
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3153250"><variable id="einamen">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable></paragraph>
+
+<section id="names">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3153250"><variable id="einamen">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable></paragraph>
+  <paragraph role="paragraph" id="par_id61702668060030">Choose <menuitem>Sheet - Named Range or Expression</menuitem></paragraph>
+</section>
 
 <section id="extlink">
   <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
@@ -282,9 +287,50 @@
   </table>
 </section>
 
+<section id="manage_names">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id751702675082804">Choose <menuitem>Sheet - Named Ranges and Expressions - Manage</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id301702675433245">Choose <menuitem>Insert - Manage Names</menuitem>.</paragraph>
+  <paragraph role="paragraph" id="par_id601702675437816">Choose <menuitem>Data - Manage Names</menuitem>.</paragraph>
+  <paragraph role="paragraph" id="par_id641702675445810">On the <menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose <menuitem>Manage</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id551702675107129">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id661702675107130" role="paragraph"><image src="cmd/lc_definename.svg" id="img_id561702675107131" width="1cm"  height="1cm"><alt id="alt_id721702675107132">Icon Manage Names</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id121702675107134" role="paragraph">Manage Names</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+    <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+  <paragraph role="paragraph" id="par_id3149385"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + F3</paragraph>
+  <h3 id="hd_id201702761733377">Other</h3>
+  <paragraph role="paragraph" id="par_id521702676756048">On the drop-down list in the <link href="text/scalc/02/06010000.xhp"><emph>Name Box</emph></link> of the <emph>Formula Bar</emph>, select <menuitem>Manage Names</menuitem>.</paragraph>
+</section>
+
 <section id="define_name">
-<paragraph role="paragraph" id="par_id3143222">Choose <menuitem>Sheet - Named Ranges and Expressions - Define</menuitem>.</paragraph>
-<paragraph role="paragraph" id="par_id3149385"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3143222">Choose <menuitem>Sheet - Named Ranges and Expressions - Define</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+  <paragraph role="paragraph" id="par_id801702661547552">Choose <menuitem>Insert - Define Name</menuitem>.</paragraph>
+  <paragraph role="paragraph" id="par_id601702661988059">Choose <menuitem>Data - Define Name</menuitem>.</paragraph>
+  <paragraph role="paragraph" id="par_id811702661629800">On the <menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose <menuitem>Define</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id11702662103998">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id871702662103999" role="paragraph"><image src="cmd/lc_label.svg" id="img_id321702662104000" width="1cm"  height="1cm"><alt id="alt_id281702662104001">Icon Define Name</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id621702662104003" role="paragraph">Define Name</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+  <h3 id="hd_id201702661733377">Other</h3>
+  <paragraph role="paragraph" id="par_id321702661807915">On the <link href="text/scalc/02/06010000.xhp"><emph>Name Box</emph></link> of the <emph>Formula Bar</emph>, insert a name for the selected cells range and press <keycode>Enter</keycode>.</paragraph>
 </section>
 
 <section id="insertnames">
@@ -295,7 +341,14 @@
   <paragraph role="paragraph" id="par_id21698845324130">On the <menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose <menuitem>Named Ranges and Expressions</menuitem>.</paragraph>
 </section>
 
-<paragraph role="paragraph" id="par_id3153558"><variable id="einaueb">Choose <menuitem>Sheet - Named Ranges and Expressions - Create</menuitem>.</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153483"><variable id="einabesch">Choose <menuitem>Sheet - Named Ranges and Expressions - Labels</menuitem>.</variable></paragraph>
+<section id="create_names">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3153558"><variable id="einaueb">Choose <menuitem>Sheet - Named Ranges and Expressions - Create</menuitem>.</variable></paragraph>
+</section>
+
+<section id="define_label_range">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id3153483"><variable id="einabesch">Choose <menuitem>Sheet - Named Ranges and Expressions - Labels</menuitem>.</variable></paragraph>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04070000.xhp b/source/text/scalc/01/04070000.xhp
index af57b50a4d..fc9c04a2e4 100644
--- a/source/text/scalc/01/04070000.xhp
+++ b/source/text/scalc/01/04070000.xhp
@@ -27,21 +27,20 @@
 </history>
 </meta>
 <body>
-<section id="namen">
 <bookmark branch="hid/.uno:NamesMenu" id="bm_id2043214" localize="false"/>
+<section id="namen">
 <h1 id="hd_id3153951"><link href="text/scalc/01/04070000.xhp">Named Ranges and Expressions</link></h1>
 <paragraph role="paragraph" id="par_id3145801"><ahelp hid=".">Allows you to name the different sections of your spreadsheet document.</ahelp> By naming the different sections, you can easily <link href="text/scalc/01/02110000.xhp">navigate</link> through the spreadsheet documents and find specific information.</paragraph>
 </section>
 <section id="howtoget">
-  <embed href="text/scalc/00/00000404.xhp#einamen"/>
+  <embed href="text/scalc/00/00000404.xhp#names"/>
 </section>
-<h2 id="hd_id3153878"><link href="text/scalc/01/04070100.xhp">Define</link></h2>
-<embed href="text/scalc/01/04070100.xhp#namenfestlegentext"/>
-<h2 id="hd_id3146969"><link href="text/scalc/01/04070200.xhp">Insert</link></h2>
-<embed href="text/scalc/01/04070200.xhp#nameneinfuegentext"/>
-<h2 id="hd_id3155764"><link href="text/scalc/01/04070300.xhp">Apply</link></h2>
-<embed href="text/scalc/01/04070300.xhp#namenuebernehmentext"/>
-<h2 id="hd_id3156382"><link href="text/scalc/01/04070400.xhp">Labels</link></h2>
-<embed href="text/scalc/01/04070400.xhp#beschtext"/>
+
+<embed href="text/scalc/01/04070100.xhp#definenames"/>
+<embed href="text/scalc/01/ManageNames.xhp#manage_names"/>
+<embed href="text/scalc/01/04070200.xhp#insertname"/>
+<embed href="text/scalc/01/04070300.xhp#create_names"/>
+<embed href="text/scalc/01/04070400.xhp#define_label_range"/>
+
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04070100.xhp b/source/text/scalc/01/04070100.xhp
index 03db97a285..5d03d25b26 100644
--- a/source/text/scalc/01/04070100.xhp
+++ b/source/text/scalc/01/04070100.xhp
@@ -22,66 +22,67 @@
 
 <meta>
 <topic id="textscalc0104070100xml" indexer="include">
-<title id="tit" xml-lang="en-US">Define Names</title>
+<title id="tit">Define Names</title>
 <filename>/text/scalc/01/04070100.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="hid/.uno:DefineName" id="bm_id4757802" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/DefineNameDialog" id="bm_id3155922" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/@@nowidget@@" id="bm_id3155922" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/ManageNamesDialog" id="bm_id3155923" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/@@nowidget@@" id="bm_id3155923" localize="false"/>
-<h1 id="hd_id3156330">Define Names</h1>
-<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US"><variable id="namenfestlegentext"><ahelp hid=".uno:DefineName">Opens a dialog where you can specify a name for a selected area or a name for a formula expression.</ahelp>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154123" xml-lang="en-US">Use the mouse to define ranges or type the reference into the <emph>Define Name </emph>dialog fields.</paragraph>
+<bookmark branch="hid/.uno:AddName" id="bm_id721702666245648" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/definename/DefineNameDialog" id="bm_id3155922" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/definename/@@nowidget@@" id="bm_id3155922" localize="false"/>
+
+<section id="definenames">
+    <h1 id="hd_id3156330"><link href="text/scalc/01/04070100.xhp">Define Names</link></h1>
+    <paragraph role="paragraph" id="par_id3154366"><variable id="namenfestlegentext"><ahelp hid=".uno:DefineName">Opens a dialog where you can specify a name for a selected area or a name for a formula expression.</ahelp></variable></paragraph>
+</section>
+
+<paragraph role="paragraph" id="par_id3154123">Use the mouse to define ranges or type the reference into the <emph>Define Name </emph>dialog fields.</paragraph>
 <section id="howtoget">
 <embed href="text/scalc/00/00000404.xhp#define_name"/>
 </section>
-<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US">The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/edit" id="bm_id3151114" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/name" id="bm_id3151115" localize="false"/>
-<h2 id="hd_id3151118">Name</h2>
-<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US"><ahelp hid=".">Enter the name of the area for which you want to define a reference or a formula expression.</ahelp> All area names already defined in the spreadsheet are listed in the text field above. If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/range" id="bm_id3145750" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/range" id="bm_id3145751" localize="false"/>
-<h2 id="hd_id3153728">Range or formula expression</h2>
-<paragraph role="paragraph" id="par_id3147435" xml-lang="en-US"><ahelp hid=".">The reference of the selected area name is shown here as an absolute value.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3146986" xml-lang="en-US">To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document. To insert a new named formula, type the formula expression.</paragraph>
-<embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/scope" id="bm_id3148455" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/scope" id="bm_id3148456" localize="false"/>
-<h2 id="hd_id31547290">Scope</h2>
-<paragraph role="paragraph" id="hd_id31547291" xml-lang="en-US" level="2"><ahelp hid=".">Select the scope of the named range or named formula. Document (Global) means the name is valid for the whole document.</ahelp> Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet. </paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/more" id="bm_id3148457" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/more" id="bm_id3148458" localize="false"/>
-<h2 id="hd_id3154729">Range options</h2>
-<paragraph role="paragraph" id="par_id3149958" xml-lang="en-US"><ahelp hid=".">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3155416" xml-lang="en-US">Defines additional options related to the type of reference area.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/printarea" id="bm_id3146972" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/printrange" id="bm_id3146973" localize="false"/>
-<h4 id="hd_id3150716">Print range</h4>
-<paragraph role="paragraph" id="par_id3150751" xml-lang="en-US"><ahelp hid=".">Defines the area as a print range.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/filter" id="bm_id3155446" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/filter" id="bm_id3155447" localize="false"/>
-<h4 id="hd_id3153764">Filter</h4>
-<paragraph role="paragraph" id="par_id3155766" xml-lang="en-US"><ahelp hid=".">Defines the selected area to be used in an <link href="text/scalc/01/12040300.xhp">advanced filter</link>.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/colheader" id="bm_id3147344" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/colheader" id="bm_id3147345" localize="false"/>
-<h4 id="hd_id3159267">Repeat column</h4>
-<paragraph role="paragraph" id="par_id3149565" xml-lang="en-US"><ahelp hid=".">Defines the area as a repeating column.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/rowheader" id="bm_id3154021" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/rowheader" id="bm_id3154022" localize="false"/>
-<h4 id="hd_id3153966">Repeat row</h4>
-<paragraph role="paragraph" id="par_id3150300" xml-lang="en-US"><ahelp hid=".">Defines the area as a repeating row.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/add" id="bm_id3150207" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/add" id="bm_id3150208" localize="false"/>
-<h2 id="hd_id3155112">Add</h2>
-<paragraph role="paragraph" id="par_id3159236" xml-lang="en-US"><ahelp hid=".">Click the <emph>Add</emph> button to add a new defined name.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/delete" id="bm_id3150209" localize="false"/>
-<embed href="text/shared/00/00000001.xhp#delete"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/names" id="bm_id3150210" localize="false"/>
-<paragraph role="paragraph" id="par_id3150301" xml-lang="en-US"><ahelp hid="modules/scalc/ui/managenamesdialog/names" visibility="hidden">Select a named range or named formula from the list to modify its properties.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155131">The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/definename/edit" id="bm_id3151114" localize="false"/>
+<section id="h2name">
+    <h2 id="hd_id3151118">Name</h2>
+    <paragraph role="paragraph" id="par_id3163712"><ahelp hid=".">Enter the name of the area for which you want to define a reference or a formula expression.</ahelp> All area names already defined in the spreadsheet are listed in the text field above. If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames.</paragraph>
+</section>
+
+<bookmark branch="hid/modules/scalc/ui/definename/range" id="bm_id3145750" localize="false"/>
+<section id="h2range">
+    <h2 id="hd_id3153728">Range or formula expression</h2>
+    <paragraph role="paragraph" id="par_id3147435"><ahelp hid=".">The reference of the selected area name is shown here as an absolute value.</ahelp></paragraph>
+    <paragraph role="paragraph" id="par_id3146986">To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document. To insert a new named formula, type the formula expression.</paragraph>
+    <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
+</section>
+
+<bookmark branch="hid/modules/scalc/ui/definename/scope" id="bm_id3148455" localize="false"/>
+<section id="h2scope">
+    <h2 id="hd_id31547290">Scope</h2>
+    <paragraph role="paragraph" id="hd_id31547291"><ahelp hid=".">Select the scope of the named range or named formula. Document (Global) means the name is valid for the whole document.</ahelp> Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet. </paragraph>
+</section>
+
+<bookmark branch="hid/modules/scalc/ui/definename/more" id="bm_id3148457" localize="false"/>
+
+<section id="h2options">
+    <h2 id="hd_id3154729">Range options</h2>
+    <paragraph role="paragraph" id="par_id3149958"><ahelp hid=".">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp></paragraph>
+    <paragraph role="paragraph" id="par_id3155416">Defines additional options related to the type of reference area.</paragraph>
+    <bookmark branch="hid/modules/scalc/ui/definename/printarea" id="bm_id3146972" localize="false"/>
+    <h3 id="hd_id3150716">Print range</h3>
+    <paragraph role="paragraph" id="par_id3150751"><ahelp hid=".">Defines the area as a print range.</ahelp></paragraph>
+    <bookmark branch="hid/modules/scalc/ui/definename/filter" id="bm_id3155446" localize="false"/>
+    <h3 id="hd_id3153764">Filter</h3>
+    <paragraph role="paragraph" id="par_id3155766"><ahelp hid=".">Defines the selected area to be used in an <link href="text/scalc/01/12040300.xhp">advanced filter</link>.</ahelp></paragraph>
+    <bookmark branch="hid/modules/scalc/ui/definename/colheader" id="bm_id3147344" localize="false"/>
+    <h3 id="hd_id3159267">Repeat column</h3>
+    <paragraph role="paragraph" id="par_id3149565"><ahelp hid=".">Defines the area as a repeating column.</ahelp></paragraph>
+    <bookmark branch="hid/modules/scalc/ui/definename/rowheader" id="bm_id3154021" localize="false"/>
+    <h3 id="hd_id3153966">Repeat row</h3>
+    <paragraph role="paragraph" id="par_id3150300"><ahelp hid=".">Defines the area as a repeating row.</ahelp></paragraph>
+    <bookmark branch="hid/modules/scalc/ui/definename/add" id="bm_id3150207" localize="false"/>
+    <h2 id="hd_id3155112">Add</h2>
+    <paragraph role="paragraph" id="par_id3159236"><ahelp hid=".">Click the <emph>Add</emph> button to add a new defined name.</ahelp></paragraph>
+</section>
+
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04070200.xhp b/source/text/scalc/01/04070200.xhp
index d634bae21a..761a9c5ed9 100644
--- a/source/text/scalc/01/04070200.xhp
+++ b/source/text/scalc/01/04070200.xhp
@@ -35,7 +35,7 @@
 <bookmark branch="hid/modules/scalc/ui/insertname/@@nowidget@@" id="bm_id3154910" localize="false"/>
 
 <section id="insertname">
-  <h1 id="hd_id3153195"><variable id="h1"><link href="text/scalc/01/04070200.xhp">Named Range or Expression</link></variable></h1>
+  <h1 id="hd_id3153195"><variable id="h1"><link href="text/scalc/01/04070200.xhp">Insert Name</link></variable></h1>
   <paragraph role="paragraph" id="par_id3150011"><variable id="nameneinfuegentext"><ahelp hid=".uno:InsertName">Inserts a defined named cell range at the current cursor's position with the <emph>Paste Names</emph> dialog.</ahelp></variable></paragraph>
 </section>
 <note id="par_id3149412">You can only insert a cell area after having defined a name for the area.</note>
diff --git a/source/text/scalc/01/04070300.xhp b/source/text/scalc/01/04070300.xhp
index 76fa81909f..95ddb6c055 100644
--- a/source/text/scalc/01/04070300.xhp
+++ b/source/text/scalc/01/04070300.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,11 +16,10 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalc0104070300xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Creating Names</title>
+<title id="tit">Creating Names</title>
 <filename>/text/scalc/01/04070300.xhp</filename>
 </topic>
 <history>
@@ -30,32 +27,35 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3147264"><bookmark_value>cell ranges;creating names automatically</bookmark_value>
+<bookmark branch="index" id="bm_id3147264"><bookmark_value>cell ranges;creating names automatically</bookmark_value>
 <bookmark_value>names; for cell ranges</bookmark_value>
 </bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:CreateNames" id="bm_id8912439" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/CreateNamesDialog" id="bm_id3150398" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/@@nowidget@@" id="bm_id3150398" localize="false"/>
-<h1 id="hd_id3147264">Creating Names</h1>
-<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><variable id="namenuebernehmentext"><ahelp hid=".uno:CreateNames">Allows you to automatically name multiple cell ranges.</ahelp>
-</variable></paragraph>
+<bookmark branch="hid/.uno:CreateNames" id="bm_id8912439" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/CreateNamesDialog" id="bm_id3150398" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/@@nowidget@@" id="bm_id3150398" localize="false"/>
+
+<section id="create_names">
+  <h1 id="hd_id3147264"><link href="text/scalc/01/04070300.xhp">Create Names</link></h1>
+<paragraph role="paragraph" id="par_id3153969"><variable id="namenuebernehmentext"><ahelp hid=".uno:CreateNames">Allows you to automatically name multiple cell ranges.</ahelp></variable></paragraph>
+</section>
+
 <section id="howtoget">
-  <embed href="text/scalc/00/00000404.xhp#einaueb"/>
+  <embed href="text/scalc/00/00000404.xhp#create_names"/>
 </section>
-<paragraph role="paragraph" id="par_id3156280" xml-lang="en-US">Select the area containing all the ranges that you want to name. Then choose <emph>Sheet - Named Ranges and Expressions - Create</emph>. This opens the <emph>Create Names</emph> dialog, from which you can select the naming options that you want.</paragraph>
+<paragraph role="paragraph" id="par_id3156280">Select the area containing all the ranges that you want to name. Then choose <emph>Sheet - Named Ranges and Expressions - Create</emph>. This opens the <emph>Create Names</emph> dialog, from which you can select the naming options that you want.</paragraph>
 <h2 id="hd_id3151116">Create names from</h2>
-<paragraph role="paragraph" id="par_id3152597" xml-lang="en-US">Defines which part of the spreadsheet is to be used for creating the name.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/top" id="bm_id3156444" localize="false"/>
+<paragraph role="paragraph" id="par_id3152597">Defines which part of the spreadsheet is to be used for creating the name.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/top" id="bm_id3156444" localize="false"/>
 <h3 id="hd_id3153729">Top row</h3>
-<paragraph role="paragraph" id="par_id3149263" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/top">Creates the range names from the header row of the selected range.</ahelp> Each column receives a separated name and cell reference.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/left" id="bm_id3145749" localize="false"/>
+<paragraph role="paragraph" id="par_id3149263"><ahelp hid="modules/scalc/ui/createnamesdialog/top">Creates the range names from the header row of the selected range.</ahelp> Each column receives a separated name and cell reference.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/left" id="bm_id3145749" localize="false"/>
 <h3 id="hd_id3146984">Left Column</h3>
-<paragraph role="paragraph" id="par_id3153190" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/left">Creates the range names from the entries in the first column of the selected sheet range.</ahelp> Each row receives a separated name and cell reference.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/bottom" id="bm_id3145645" localize="false"/>
+<paragraph role="paragraph" id="par_id3153190"><ahelp hid="modules/scalc/ui/createnamesdialog/left">Creates the range names from the entries in the first column of the selected sheet range.</ahelp> Each row receives a separated name and cell reference.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/bottom" id="bm_id3145645" localize="false"/>
 <h3 id="hd_id3156284">Bottom row</h3>
-<paragraph role="paragraph" id="par_id3147124" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/bottom">Creates the range names from the entries in the last row of the selected sheet range.</ahelp> Each column receives a separated name and cell reference.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/right" id="bm_id3145253" localize="false"/>
+<paragraph role="paragraph" id="par_id3147124"><ahelp hid="modules/scalc/ui/createnamesdialog/bottom">Creates the range names from the entries in the last row of the selected sheet range.</ahelp> Each column receives a separated name and cell reference.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/createnamesdialog/right" id="bm_id3145253" localize="false"/>
 <h3 id="hd_id3154731">Right Column</h3>
-<paragraph role="paragraph" id="par_id3153158" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/right">Creates the range names from the entries in the last column of the selected sheet range.</ahelp> Each row receives a separated name and cell reference.</paragraph>
+<paragraph role="paragraph" id="par_id3153158"><ahelp hid="modules/scalc/ui/createnamesdialog/right">Creates the range names from the entries in the last column of the selected sheet range.</ahelp> Each row receives a separated name and cell reference.</paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04070400.xhp b/source/text/scalc/01/04070400.xhp
index 6ed548c49d..60fef5b4a8 100644
--- a/source/text/scalc/01/04070400.xhp
+++ b/source/text/scalc/01/04070400.xhp
@@ -22,45 +22,47 @@
 
 <meta>
 <topic id="textscalc0104070400xml" indexer="include">
-<title id="tit" xml-lang="en-US">Define Label Range</title>
+<title id="tit">Define Label Range</title>
 <filename>/text/scalc/01/04070400.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3150791"><bookmark_value>sheets; defining label ranges</bookmark_value>
+<bookmark branch="index" id="bm_id3150791"><bookmark_value>sheets; defining label ranges</bookmark_value>
 <bookmark_value>label ranges in sheets</bookmark_value>
 </bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:DefineLabelRange" id="bm_id9319643" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/NameRangesDialog" id="bm_id3150447" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/@@nowidget@@" id="bm_id3150447" localize="false"/>
-<paragraph role="heading" id="hd_id3150791" xml-lang="en-US" level="1"><variable id="define_label_range"><link href="text/scalc/01/04070400.xhp">Define Label Range</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150868" xml-lang="en-US"><variable id="beschtext"><ahelp hid=".uno:DefineLabelRange">Opens a dialog in which you can define a label range.</ahelp>
-</variable></paragraph>
+<bookmark branch="hid/.uno:DefineLabelRange" id="bm_id9319643" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/NameRangesDialog" id="bm_id3150447" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/@@nowidget@@" id="bm_id3150447" localize="false"/>
+
+<section id="define_label_range">
+    <h1 id="hd_id3150791"><link href="text/scalc/01/04070400.xhp">Define Label Range</link></h1>
+    <paragraph role="paragraph" id="par_id3150868"><variable id="beschtext"><ahelp hid=".uno:DefineLabelRange">Opens a dialog in which you can define a label range.</ahelp></variable></paragraph>
+</section>
+
 <section id="howtoget">
-<embed href="text/scalc/00/00000404.xhp#einabesch"/>
+<embed href="text/scalc/00/00000404.xhp#define_label_range"/>
 </section>
 <embed href="text/scalc/guide/address_auto.xhp#address_auto"/>
-<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US">The cell contents of a label range can be used like names in formulas - $[officename] recognizes these names in the same manner that it does the predefined names of the weekdays and months. These names are automatically completed when typed into a formula. In addition, the names defined by label ranges will have priority over names defined by automatically generated ranges.</paragraph>
-<paragraph role="note" id="par_id3147435" xml-lang="en-US">You can set label ranges that contain the same labels on different sheets. $[officename] first searches the label ranges of the current sheet and, following a failed search, the ranges of other sheets.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/range" id="bm_id3149958" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/edassign" id="bm_id3148457" localize="false"/>
+<paragraph role="paragraph" id="par_id3155411">The cell contents of a label range can be used like names in formulas - $[officename] recognizes these names in the same manner that it does the predefined names of the weekdays and months. These names are automatically completed when typed into a formula. In addition, the names defined by label ranges will have priority over names defined by automatically generated ranges.</paragraph>
+<note id="par_id3147435">You can set label ranges that contain the same labels on different sheets. $[officename] first searches the label ranges of the current sheet and, following a failed search, the ranges of other sheets.</note>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/range" id="bm_id3149958" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/edassign" id="bm_id3148457" localize="false"/>
 <h2 id="hd_id3145801">Range</h2>
-<paragraph role="paragraph" id="par_id3154731" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/edassign">Displays the cell reference of each label range.</ahelp> In order to remove a label range from the list box, select it and then click <emph>Delete</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3154731"><ahelp hid="modules/scalc/ui/namerangesdialog/edassign">Displays the cell reference of each label range.</ahelp> In order to remove a label range from the list box, select it and then click <emph>Delete</emph>.</paragraph>
 <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/colhead" id="bm_id3155064" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/colhead" id="bm_id3155064" localize="false"/>
 <h3 id="hd_id3149121">Contains column labels</h3>
-<paragraph role="paragraph" id="par_id3150330" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/colhead">Includes column labels in the current label range.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/rowhead" id="bm_id3145642" localize="false"/>
+<paragraph role="paragraph" id="par_id3150330"><ahelp hid="modules/scalc/ui/namerangesdialog/colhead">Includes column labels in the current label range.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/rowhead" id="bm_id3145642" localize="false"/>
 <h3 id="hd_id3149020">Contains row labels</h3>
-<paragraph role="paragraph" id="par_id3154754" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/rowhead">Includes row labels in the current label range.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/edassign2" id="bm_id3146919" localize="false"/>
+<paragraph role="paragraph" id="par_id3154754"><ahelp hid="modules/scalc/ui/namerangesdialog/rowhead">Includes row labels in the current label range.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/edassign2" id="bm_id3146919" localize="false"/>
 <h3 id="hd_id3159264">For data range</h3>
-<paragraph role="paragraph" id="par_id3154703" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/edassign2">Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154703"><ahelp hid="modules/scalc/ui/namerangesdialog/edassign2">Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse.</ahelp></paragraph>
 <embed href="text/shared/00/00000001.xhp#shrink_maximize"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/add" id="bm_id3150299" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/namerangesdialog/add" id="bm_id3150299" localize="false"/>
 <h2 id="hd_id3145789">Add</h2>
-<paragraph role="paragraph" id="par_id3147005" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/add">Adds the current label range to the list.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3147005"><ahelp hid="modules/scalc/ui/namerangesdialog/add">Adds the current label range to the list.</ahelp></paragraph>
 <embed href="text/shared/00/00000001.xhp#delete"/>
 <section id="relatedtopics">
 <embed href="text/scalc/guide/address_auto.xhp#address_auto"/>
diff --git a/source/text/scalc/01/ManageNames.xhp b/source/text/scalc/01/ManageNames.xhp
new file mode 100644
index 0000000000..c2b14007d0
--- /dev/null
+++ b/source/text/scalc/01/ManageNames.xhp
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+    <!--
+    * This file is part of the LibreOffice project.
+    *
+    * This Source Code Form is subject to the terms of the Mozilla Public
+    * License, v. 2.0. If a copy of the MPL was not distributed with this
+    * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+    *
+    -->
+
+    <meta>
+        <topic id="textscalc01ManageNamesxhp" indexer="include" status="PUBLISH">
+            <title id="tit">Manage Names</title>
+            <filename>/text/scalc/01/ManageNames.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/ManageNamesDialog" id="bm_id3155923" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/@@nowidget@@" id="bm_id3155923" localize="false"/>
+    <bookmark branch="hid/.uno:DefineName" id="bm_id4757802" localize="false"/>
+    <section id="manage_names">
+        <h1 id="hd_id511702671562154"><variable id="h1"><link href="text/scalc/01/ManageNames.xhp">Manage Names</link></variable></h1>
+        <paragraph id="par_id971702671562156" role="paragraph">Opens a dialog where you can manage names in the spreadsheet.</paragraph>
+    </section>
+
+    <section id="howtoget">
+        <embed href="text/scalc/00/00000404.xhp#manage_names"/>
+    </section>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/names" id="bm_id3150210" localize="false"/>
+    <h2 id="hd_id421702675891023">Names area</h2>
+    <paragraph role="paragraph" id="par_id3150301"><ahelp hid="modules/scalc/ui/managenamesdialog/names">Select a named range or named formula from the list to modify its properties.</ahelp></paragraph>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/name" id="bm_id3151115" localize="false"/>
+    <embed href="text/scalc/01/04070100.xhp#h2name"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/range" id="bm_id3145751" localize="false"/>
+    <embed href="text/scalc/01/04070100.xhp#h2range"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/scope" id="bm_id3148456" localize="false"/>
+    <embed href="text/scalc/01/04070100.xhp#h2scope"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/more" id="bm_id3148458" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/printrange" id="bm_id3146973" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/filter" id="bm_id3155447" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/colheader" id="bm_id3147345" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/rowheader" id="bm_id3154022" localize="false"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/add" id="bm_id3150208" localize="false"/>
+    <embed href="text/scalc/01/04070100.xhp#h2options"/>
+    <bookmark branch="hid/modules/scalc/ui/managenamesdialog/delete" id="bm_id3150209" localize="false"/>
+    <embed href="text/shared/00/00000001.xhp#delete"/>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index 9e525c979e..4afdc0506d 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -49,10 +49,11 @@
 <embed href="text/scalc/01/04050100.xhp#sheetfromfile"/>
 <embed href="text/scalc/01/04090000.xhp#extdata"/>
 <embed href="text/scalc/01/02170000.xhp#deletesheet"/>
+<embed href="text/scalc/01/02150000.xhp#del_contents"/>
 <embed href="text/scalc/01/ToggleRelative.xhp#cycle_types"/>
 <embed href="text/scalc/01/02140000.xhp#fill"/>
+<embed href="text/scalc/01/04070000.xhp#namen"/>
 
-<embed href="text/scalc/01/02150000.xhp#del_contents"/>
 
 <h2 id="hd_id3150792"><link href="text/scalc/01/02180000.xhp">Move or Copy Sheet</link></h2>
 <embed href="text/scalc/01/02180000.xhp#tabelleverschiebenkopierentext"/>