<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Data Menu</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="fuzzysort.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="en-US/langnames.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body itemscope="true" itemtype="http://schema.org/TechArticle">
<div class="header-extrawurst">
<header><div class="logo-container"><a class="logo" href="en-US/text/shared/05/new_help.html"><div class="symbol"></div>
<p>LibreOffice 6.4 Help</p></a></div></header><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" onclick="setupModules('', 'en-US');">Module</button><nav id="modules-nav"></nav>
</div>
</div>
<aside class="rightside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1">Contents</label><div id="Contents" class="contents-treeview"></div></aside><aside class="leftside"><div id="Index">
<div class="index-label">Index 🔎︎ </div>
<div id="Bookmarks">
<input id="search-bar" type="text" class="search" placeholder="Search in chosen module"><nav class="index"></nav>
</div>
</div></aside><div id="DisplayArea" itemprop="articleBody">
<h1 itemprop="articleSection" id="hd_id3145136">Data Menu</h1>
<p id="par_id8366954" class="paragraph"><a name="text2columns"></a>Choose <span class="emph">Data - Text to Columns</span>.</p>
<p id="par_id3147399" class="paragraph"><a name="dbrbf"></a>Choose <span class="emph">Data - Define Range</span>.</p>
<p id="par_id3145345" class="paragraph"><a name="dbrba"></a>Choose <span class="emph">Data - Select Range</span>.</p>
<p id="par_id3150443" class="paragraph"><a name="dnsrt"></a>Choose <span class="emph">Data - Sort...</span>.</p>
<a name="dnsosk"></a>
<p id="par_id3148491" class="paragraph">Choose <span class="emph">Data - Sort - Sort Criteria</span> tab.</p>
<p id="par_id3154516" class="paragraph">On <span class="emph">Standard</span> bar, click</p>
<a name="sysortieren"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3148663" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_sortascending.svg" class="iconimage" alt="Icon" title="Icon" style="width:16px;height:16px"></p>
</div>
<div class="iconcell">
<p id="par_id3150767" class="paragraphintable">Sort Ascending</p>
</div>
</div>
<div class="icontable">
<div class="iconcell">
<p id="par_id3153969" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_sortdescending.svg" class="iconimage" alt="Icon" title="Icon" style="width:16px;height:16px"></p>
</div>
<div class="iconcell">
<p id="par_id3145364" class="paragraphintable">Sort Descending</p>
</div>
</div>
<p id="par_id3146984" class="paragraph"><a name="dnstot"></a>Choose <span class="emph">Data - Sort - Options</span> tab.</p>
<p id="par_id3155308" class="paragraph"><a name="dnftr"></a>Choose <span class="emph">Data - More Filters</span>.</p>
<a name="dnfiafi"></a>
<p id="par_id3148646" class="paragraph">Choose <span class="emph">Data - AutoFilter</span>.</p>
<p id="par_id3151113" class="paragraph">On <span class="emph">Tools</span> bar or <span class="emph">Table Data</span> bar, click</p>
<a name="syautofilter"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3145799" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_datafilterautofilter.svg" class="iconimage" alt="Icon" title="Icon" style="width:21px;height:21px"></p>
</div>
<div class="iconcell">
<p id="par_id3149401" class="paragraphintable">AutoFilter</p>
</div>
</div>
<p id="par_id3156278" class="paragraph"><a name="dnfspz"></a>Choose <span class="emph">Data - More Filters - Advanced Filter...</span> .</p>
<a name="filterzus"></a>
<p id="par_id3153764" class="paragraph">Choose <span class="emph">Data - More Filters - Standard Filter... - Options</span> label.</p>
<p id="par_id3155444" class="paragraph">Choose <span class="emph">Data - More Filters - Advanced Filter... - Options</span> label.</p>
<a name="dnfief"></a>
<p id="par_id3156382" class="paragraph">Choose <span class="emph">Data - More Filters - Reset Filter</span>.</p>
<p id="par_id3155961" class="paragraph">On <span class="emph">Table Data</span> bar, click <span class="emph">Reset Filter/Sort</span>.</p>
<div class="icontable">
<div class="iconcell">
<p id="par_id3148485" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_removefiltersort.svg" class="iconimage" alt="Icon" title="Icon" style="width:21px;height:21px"></p>
</div>
<div class="iconcell">
<p id="par_id3149207" class="paragraphintable">Reset Filter/Sort</p>
</div>
</div>
<p id="par_id3152778" class="paragraph"><a name="dnaftas"></a>Choose <span class="emph">Data - More Filter - Hide AutoFilter</span>.</p>
<p id="par_id3166424" class="paragraph"><a name="dntegs"></a>Choose <span class="emph">Data - Subtotals</span>.</p>
<p id="par_id3154574" class="paragraph"><a name="dntezd"></a>Choose <span class="emph">Data - Subtotals - 1st, 2nd, 3rd Group</span> tabs.</p>
<p id="par_id3151277" class="paragraph"><a name="dntopi"></a>Choose <span class="emph">Data - Subtotals - Options</span> tab.</p>
<p id="par_id3145133" class="paragraph"><a name="datengueltig"></a>Choose <span class="emph">Data - Validity</span>.</p>
<p id="par_id3152992" class="paragraph"><a name="datengueltigwerte"></a>Menu <span class="emph">Data - Validity - Criteria</span> tab.</p>
<p id="par_id3150367" class="paragraph"><a name="datengueltigeingabe"></a>Choose <span class="emph">Data - Validity - Input Help</span> tab.</p>
<p id="par_id3154486" class="paragraph"><a name="datengueltigfehler"></a>Choose <span class="emph">Data - Validity - Error Alert</span> tab.</p>
<p id="par_id3146978" class="paragraph"><a name="dnmfo"></a>Choose <span class="emph">Data - Multiple Operations</span>.</p>
<p id="par_id3155809" class="paragraph"><a name="dnksd"></a>Choose <span class="emph">Data - Consolidate</span>.</p>
<p id="par_id3148701" class="paragraph"><a name="dngld"></a>Choose <span class="emph">Data - Group and Outline</span>.</p>
<p id="par_id3153815" class="paragraph"><a name="dngda"></a>Choose <span class="emph">Data - Group and Outline - Hide Details</span>.</p>
<p id="par_id3159223" class="paragraph"><a name="dngde"></a>Choose <span class="emph">Data - Group and Outline - Show Details</span>.</p>
<a name="dnglgr"></a>
<p id="par_id3146870" class="paragraph">Choose <span class="emph">Data - Group and Outline - Group</span>.</p>
<p id="par_id3144507" class="paragraph">F12</p>
<p id="par_id3144772" class="paragraph">On <span class="emph">Tools</span> bar, click</p>
<a name="sygruppieren"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3149438" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_group.svg" class="iconimage" alt="Icon" title="Icon" style="width:21px;height:21px"></p>
</div>
<div class="iconcell">
<p id="par_id3150214" class="paragraphintable">Group</p>
</div>
</div>
<a name="dnglgra"></a>
<p id="par_id3146781" class="paragraph">Choose <span class="emph">Data - Group and Outline - Ungroup</span>.</p>
<p id="par_id3150892" class="paragraph"><span id="swlnsysidm142" class="switchinline"><span hidden="true" id="MACidm143" class="MAC">Command</span><span hidden="true" id="defaultidm144">Ctrl</span></span>+F12</p>
<p id="par_id3155097" class="paragraph">On <span class="emph">Tools</span> bar, click</p>
<a name="sygruppierungaufheben"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3150048" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_ungroup.svg" class="iconimage" alt="Icon" title="Icon" style="width:21px;height:21px"></p>
</div>
<div class="iconcell">
<p id="par_id3153555" class="paragraphintable">Ungroup</p>
</div>
</div>
<p id="par_id3153008" class="paragraph"><a name="dnglagl"></a>Choose <span class="emph">Data - Group and Outline - AutoOutline</span>.</p>
<p id="par_id3154709" class="paragraph"><a name="dnglef"></a>Choose <span class="emph">Data - Group and Outline - Remove Outline</span>.</p>
<p id="par_id1774346" class="paragraph"><a name="dngdrill"></a>Choose <span class="emph">Data - Group and Outline - Show Details</span> (for some pivot tables).</p>
<p id="par_id3155759" class="paragraph"><a name="dndtpt"></a>Choose <span class="emph">Data - Pivot Table</span>.</p>
<p id="par_id3154625" class="paragraph"><a name="dndpa"></a>Choose <span class="emph">Insert - Pivot Table</span>.</p>
<p id="par_id3147558" class="paragraph"><a name="dndq"></a>Choose <span class="emph">Insert - Pivot Table</span>, in the <span class="emph">Select Source</span> dialog choose the option <span class="emph">Data source registered in LibreOffice</span>.</p>
<a name="dndpaz"></a>
<p id="par_id3153297" class="paragraph">Choose <span class="emph">Insert - Pivot Table</span>, in the <span class="emph">Select Source</span> dialog choose the option <span class="emph">Current selection</span>.</p>
<p id="par_id3145118" class="paragraph">Choose <span class="emph">Insert - Pivot Table</span>, in the <span class="emph">Select Source</span> dialog choose the option <span class="emph">Data source registered in LibreOffice</span>, click <span class="emph">OK</span> to see <span class="emph">Select Data Source</span> dialog.</p>
<p id="par_id3153294" class="paragraph"><a name="dndpak"></a>Choose <span class="emph">Data - Pivot Table - Refresh</span>.</p>
<p id="par_id3151344" class="paragraph"><a name="dndploe"></a>Choose <span class="emph">Data - Pivot Table - Delete</span>.</p>
<p id="par_id3150397" class="paragraph"><a name="dndakt"></a>Choose <span class="emph">Data - Refresh Range</span>.</p>
<p id="par_idN10B8F" class="paragraph"><a name="grouping"></a>Choose <span class="emph">Data - Group and Outline - Group</span>.</p>
</div>
<div class="search-frame"></div>
<div class="donation-frame"></div>
<footer><div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p>This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/scalc/00/00000412.xhp" target="_blank">/text/scalc/00/00000412.xhp</a></p>
<p>Title is: Data Menu</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>