__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<!DOCTYPE html>
<html lang="es" dir="ltr">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Filtrar intervalos de celdas</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="es/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.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="paginathing.js" defer></script><script type="text/javascript" src="es/bookmarks.js" defer></script><script type="text/javascript" src="es/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>
<header id="TopLeftHeader"><a class="symbol" href="es/text/shared/05/new_help.html"><div></div></a><a class="logo" href="es/text/shared/05/new_help.html"><p dir="auto">Ayuda de LibreOffice 25.2</p></a><div class="dropdowns"><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Módulo</button><nav id="modules-nav" hidden=""></nav>
</div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contenido</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks">
<input id="search-bar" type="search" class="search" placeholder="Buscar en los marcadores del módulo elegido" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div>
</div></div>
<div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication">
<noscript><div id="WarnJS"><h1 dir="auto">Active JavaScript en el navegador para mostrar las páginas de ayuda de LibreOffice.</h1></div></noscript>
<a id="bm_id3153541"></a><meta itemprop="keywords" content="áreas de celdas,aplicar/quitar filtros"> <meta itemprop="keywords" content="filtrar,áreas de celdas/áreas de base de datos"> <meta itemprop="keywords" content="áreas de base de datos,aplicar/quitar filtros"> <meta itemprop="keywords" content="eliminar,filtros de áreas de celdas">
<h1 id="hd_id3153541" dir="auto">
<a id="database_filter"></a>Filtrar intervalos de celdas</h1>
<p id="par_id3145069" class="paragraph" dir="auto">Puede usar varios filtros para filtrar los intervalos de celdas en las hojas de cálculo. Un filtro estándar utiliza las opciones especificadas para filtrar los datos. Un filtro automático filtra los datos de acuerdo con una cadena o un valor que se especifique. Un filtro avanzado utiliza los criterios de filtrado de celdas específicas.</p>
<h2 id="par_idN10682" dir="auto">Para aplicar un filtro estándar en un intervalo de celdas</h2>
<ol itemprop="HowTo" itemscope="true" itemtype="http://schema.org/HowToSection" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3150398" class="listitem" dir="auto">Pulse en un intervalo de celdas.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_idN10693" class="listitem" dir="auto">Vaya a <span class="menuitem">Datos ▸ Más filtros ▸ Filtro estándar</span>.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3156422" class="listitem" dir="auto">En el cuadro de diálogo <span class="emph">Filtro estándar</span>, especifique las opciones de filtro que desee.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_idN106A5" class="listitem" dir="auto">Pulse en <span class="emph">Aceptar</span>.</p>
<p id="par_id3153143" class="paragraph" dir="auto">Se muestran los registros que coinciden con las opciones de filtro especificadas.</p>
</li>
</ol>
<h2 id="par_id3153728" dir="auto">Para aplicar un filtro automático en un intervalo de celdas</h2>
<ol itemprop="HowTo" itemscope="true" itemtype="http://schema.org/HowToSection" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3144764" class="listitem" dir="auto">Pulse en un intervalo de celdas o un intervalo de una base de datos.</p>
<div class="tip">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/tip.svg" alt="Icono de consejo" style="width:40px;height:40px;"></div>
<div class="notetext"><p dir="auto">Si desea aplicar varios filtros automáticos a la misma hoja, primero debe definir intervalos de base de datos para, a continuación, aplicar los filtros automáticos a esos intervalos.</p></div>
</div>
<br>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3154944" class="listitem" dir="auto">Vaya a <span class="menuitem">Datos ▸ Filtro automático</span>.</p>
<p id="par_idN106DB" class="listitem" dir="auto">Se añadirá un botón de flecha en la parte superior de cada columna del intervalo de base de datos.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_id3153878" class="listitem" dir="auto">Pulse en el botón de flecha de la columna que contenga el valor o la cadena que quiera configurar como criterio de filtro.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_idN10749" class="listitem" dir="auto">Seleccione el valor o la cadena que desee utilizar como criterio de filtro.</p>
<p id="par_idN1074C" class="listitem" dir="auto">Se muestran los registros que coinciden con las opciones de filtro especificadas.</p>
</li>
</ol>
<h2 id="par_idN106E8" dir="auto">Para eliminar un filtro de un intervalo de celdas</h2>
<ol itemprop="HowTo" itemscope="true" itemtype="http://schema.org/HowToSection" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_idN1075C" class="paragraph" dir="auto">Pulse en un intervalo de celdas filtrado.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto">
<p id="par_idN106EC" class="paragraph" dir="auto">Vaya a <span class="menuitem">Datos ▸ Filtro ▸ Restablecer filtro</span>.</p>
</li>
</ol>
<a id="relatedtopics"></a><div class="relatedtopics">
<p class="related" itemprop="mentions" dir="auto"><a id="related"></a><span class="emph">Temas relacionados</span></p>
<div class="relatedbody" itemprop="mentions">
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/scalc/guide/database_define.html">Definir un intervalo de base de datos</a></p></div>
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/scalc/guide/database_sort.html">Ordenar datos</a></p></div>
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/scalc/guide/cellcopy.html">Copiar solo celdas visibles</a></p></div>
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/scalc/guide/specialfilter.html">Aplicar filtros avanzados</a></p></div>
<p id="par_id4525284" class="paragraph" dir="auto"><a target="_blank" href="https://wiki.documentfoundation.org/Documentation/How_Tos/Defining_a_Data_Range">Página del wiki sobre la definición de un intervalo de datos</a></p>
</div>
</div>
</div>
<div id="DonationFrame"></div>
<footer><h2 style="text-align: center;"><a href="https://books.libreoffice.org" target="_blank">Libros de LibreOffice</a></h2>
<div class="noteicon" dir="auto" style="display:flex;justify-content:center;flex-wrap:wrap;row-gap:15px;">
<img src="media/navigation/libo-writer.svg" alt="Writer Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-calc.svg" alt="Calc Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-impress.svg" alt="Impress Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-draw.svg" alt="Draw Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-base.svg" alt="Base Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-math.svg" alt="Math Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-symbol-black.svg" alt="Getting Started Icon" style="width:60px;height:60px;">
</div>
<div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/scalc/guide/database_filter.xhp" target="_blank">/text/scalc/guide/database_filter.xhp</a></p>
<p dir="auto">Title is: Filtrar intervalos de celdas</p>
<p id="bm_module" dir="auto"></p>
<p id="bm_system" dir="auto"></p>
<p id="bm_HID" dir="auto"></p>
</div></footer>
</body>
</html>
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| address_auto.html | File | 8.38 KB | 0644 |
|
| auto_off.html | File | 8.69 KB | 0644 |
|
| autofilter.html | File | 9.01 KB | 0644 |
|
| autoformat.html | File | 8.89 KB | 0644 |
|
| background.html | File | 7.14 KB | 0644 |
|
| borders.html | File | 19.28 KB | 0644 |
|
| calc_date.html | File | 7.81 KB | 0644 |
|
| calc_series.html | File | 10.44 KB | 0644 |
|
| calc_timevalues.html | File | 5.14 KB | 0644 |
|
| calculate.html | File | 6.74 KB | 0644 |
|
| cell_enter.html | File | 7.3 KB | 0644 |
|
| cell_protect.html | File | 10.78 KB | 0644 |
|
| cell_unprotect.html | File | 5.62 KB | 0644 |
|
| cellcopy.html | File | 7.74 KB | 0644 |
|
| cellreference_dragdrop.html | File | 7.72 KB | 0644 |
|
| cellreferences.html | File | 11.9 KB | 0644 |
|
| cellreferences_url.html | File | 7.96 KB | 0644 |
|
| cellstyle_by_formula.html | File | 7.65 KB | 0644 |
|
| cellstyle_conditional.html | File | 15.61 KB | 0644 |
|
| cellstyle_minusvalue.html | File | 6.35 KB | 0644 |
|
| change_image_anchor.html | File | 6.32 KB | 0644 |
|
| consolidate.html | File | 10.92 KB | 0644 |
|
| csv_files.html | File | 11.55 KB | 0644 |
|
| csv_formula.html | File | 10.76 KB | 0644 |
|
| currency_format.html | File | 8.22 KB | 0644 |
|
| database_define.html | File | 7.69 KB | 0644 |
|
| database_filter.html | File | 9.68 KB | 0644 |
|
| database_sort.html | File | 6.41 KB | 0644 |
|
| datapilot.html | File | 6.16 KB | 0644 |
|
| datapilot_createtable.html | File | 10.48 KB | 0644 |
|
| datapilot_deletetable.html | File | 6.3 KB | 0644 |
|
| datapilot_edittable.html | File | 7.81 KB | 0644 |
|
| datapilot_filtertable.html | File | 10.38 KB | 0644 |
|
| datapilot_formatting.html | File | 8.92 KB | 0644 |
|
| datapilot_grouping.html | File | 7.26 KB | 0644 |
|
| datapilot_tipps.html | File | 6.88 KB | 0644 |
|
| datapilot_updatetable.html | File | 6.19 KB | 0644 |
|
| dbase_files.html | File | 11.02 KB | 0644 |
|
| design.html | File | 7.99 KB | 0644 |
|
| edit_multitables.html | File | 6.62 KB | 0644 |
|
| filters.html | File | 7.62 KB | 0644 |
|
| finding.html | File | 10.58 KB | 0644 |
|
| format_table.html | File | 8.82 KB | 0644 |
|
| format_value.html | File | 7.63 KB | 0644 |
|
| format_value_userdef.html | File | 9.76 KB | 0644 |
|
| formula_copy.html | File | 7.72 KB | 0644 |
|
| formula_enter.html | File | 8.59 KB | 0644 |
|
| formula_value.html | File | 6.03 KB | 0644 |
|
| formulas.html | File | 8.04 KB | 0644 |
|
| fraction_enter.html | File | 5.9 KB | 0644 |
|
| goalseek.html | File | 8.18 KB | 0644 |
|
| html_doc.html | File | 7.58 KB | 0644 |
|
| integer_leading_zero.html | File | 8.69 KB | 0644 |
|
| keyboard.html | File | 11.18 KB | 0644 |
|
| line_fix.html | File | 7.31 KB | 0644 |
|
| main.html | File | 22.03 KB | 0644 |
|
| mark_cells.html | File | 9.18 KB | 0644 |
|
| matrixformula.html | File | 6.91 KB | 0644 |
|
| move_dragdrop.html | File | 12.43 KB | 0644 |
|
| multi_tables.html | File | 7.63 KB | 0644 |
|
| multioperation.html | File | 13.52 KB | 0644 |
|
| multitables.html | File | 6.77 KB | 0644 |
|
| note_insert.html | File | 7.54 KB | 0644 |
|
| numbers_text.html | File | 12.24 KB | 0644 |
|
| pivotchart.html | File | 6.17 KB | 0644 |
|
| pivotchart_create.html | File | 7.84 KB | 0644 |
|
| pivotchart_delete.html | File | 5.96 KB | 0644 |
|
| pivotchart_edit.html | File | 9.88 KB | 0644 |
|
| pivotchart_filter.html | File | 6.71 KB | 0644 |
|
| pivotchart_update.html | File | 6.06 KB | 0644 |
|
| print_details.html | File | 7.93 KB | 0644 |
|
| print_exact.html | File | 6.63 KB | 0644 |
|
| print_landscape.html | File | 9.3 KB | 0644 |
|
| print_title_row.html | File | 8.69 KB | 0644 |
|
| printranges.html | File | 10.55 KB | 0644 |
|
| relativ_absolut_ref.html | File | 15.06 KB | 0644 |
|
| remove_duplicates.html | File | 7.93 KB | 0644 |
|
| rename_table.html | File | 11.37 KB | 0644 |
|
| rounding_numbers.html | File | 8.35 KB | 0644 |
|
| row_height.html | File | 7.27 KB | 0644 |
|
| scenario.html | File | 9.74 KB | 0644 |
|
| sorted_list.html | File | 6.63 KB | 0644 |
|
| specialfilter.html | File | 14.18 KB | 0644 |
|
| subtotaltool.html | File | 9.5 KB | 0644 |
|
| super_subscript.html | File | 5.9 KB | 0644 |
|
| table_cellmerge.html | File | 13.29 KB | 0644 |
|
| table_rotate.html | File | 6.15 KB | 0644 |
|
| table_view.html | File | 6.5 KB | 0644 |
|
| text_numbers.html | File | 6.6 KB | 0644 |
|
| text_rotate.html | File | 5.76 KB | 0644 |
|
| text_wrap.html | File | 6.23 KB | 0644 |
|
| userdefined_function.html | File | 11.89 KB | 0644 |
|
| validity.html | File | 10.36 KB | 0644 |
|
| value_with_name.html | File | 10.87 KB | 0644 |
|
| webquery.html | File | 10.32 KB | 0644 |
|
| wildcards.html | File | 12.76 KB | 0644 |
|
| year2000.html | File | 5.59 KB | 0644 |
|