Filtrum in Excel

Si Excel vis ostendere tantum monumenta quae certis indiciis occurrunt, filtrum utere. Quia haec:

  1. Preme cellam aliquam in dataset.
  2. In Provectus tab Data (Indicium) click Filter (Colum). Sagittae in columna capitulorum apparent.Filtrum in Excel
  3. Click in sagitta iuxta titulum Patriae.
  4. Click in linea Desumo omnes (Select All) ut omnes checkboxes purgare, capsam tunc reprehendo USA.Filtrum in Excel
  5. Press OK.Result: Excel tantum ostendit US venditio data.Filtrum in Excel
  6. Click in sagitta iuxta titulum quarter.
  7. Click in linea Desumo omnes (Select All) ut omnes checkboxes purgare, capsam tunc reprehendo Qtr 4.Filtrum in Excel
  8. Press OK.Result: Excel tantum ostendit quarta quarta venditionesque US data.Filtrum in Excel
  9. Ad evacuandam eliquare, in tab Data (Indicium) click tersus (patet). Colum omnino tollere, id est sagittas tollere, iterum premere Filter (Colum).Filtrum in Excel

Leave a Reply