Peñera automática

Peñera automáticamente l'área de caxelles escoyida, y crea cuadros de llista d'una filera nos que pue escoyer los elementos que deseya amosar.

P'aportar a esta orde...

Dende la barra de menús:

Choose Data - AutoFilter.

Dende la interfaz con llingüetes:

Escueyi Datos - Peñera automática.

Nel menú Datos de la llingüeta Datos, escueyi Peñera automática.

Dende les barres de ferramientes:

Iconu Peñera automática

Peñera automática

Col tecláu:

+ Shift + L


tip

P'asignar distintos AutoFiltros a distintes fueyes, debes primero definir el rangu de la base de datos en cada fueya.


Sort Ascending

Displays the rows of the cell range in ascending order, based on the values in the cells of the current column.

Sort Descending

Displays the rows of the cell range in descending order, based on the values in the cells of the current column.

Filter by Color

Color del testu

Displays only the rows of the cell range for which the text color of the cell in the current column matches the color selected.

Color de fondu

Displays only the rows of the cell range for which the background color of the cell in the current column matches the color selected.

Filter by Condition

Baleru

Displays only the rows of the cell range that have an empty cell in the current column.

Non baleru

Displays only the rows of the cell range that have a non-empty cell in the current column.

Top 10

Displays the 10 rows of the cell range that contain the largest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown.

Bottom 10

Displays the 10 rows of the cell range that contain the lowest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown.

Peñera estándar

Abre'l diálogu Peñera estándar.

Search text box

Search for a specific entry in the list of values found in the current column. As characters are typed in the text box, this list is updated to show only matching entries.

All

Click once to select to show all rows and click again to select to hide all rows.

Show only current item

Display only rows containing the value highlighted in the Value box.

Hide only current item

Hide all rows containing the value highlighted in the Value box and display all other rows.

Valores

List of unique values found in the current column.

Please support us!