Mokhoa oa ho sebelisa li-filters ho Google Sheets?

‍ Mokhoa oa ho kenya li-filters⁢ ho Google Sheets?

Hore na o hloka ho hlophisa lintlha, ho etsa tlhahlobo, kapa ho fumana lintlha tse ikhethileng holim'a lakane palo, li-filters ho Google Sheets Li tla u lumella ho boloka nako le ho tsamaisa taolo ea data e ngata. Ka tshebetso ena, u tla khona ho lokisa maemo a ho batla 'me u bontše feela lintlha tse lumellanang le tsona. Sehloohong sena u tla ithuta mohato ka mohato mokhoa oa ho kenya li-filters ho Lipampiri tsa Google 'me u sebelise sesebelisoa sena hamolemo.

Mohato oa 1: Bula leqephe la hau ho Google Sheets

Ea pele eo o tlameha ho etsa es bula spreadsheet ea hau ho Google Sheets. U ka etsa leqephe le lecha kapa ua sebetsa ho le teng, ho latela litlhoko tsa hau. Hang ha o se o kene ho Google Sheets, khetha leqephe leo u batlang ho kenya filtara ho lona.

Mohato oa 2: Khetha mofuta oa data

Pele o sebelisa filthara, o tlameha ho khetha lethathamo la data eo u batlang ho e sebelisa ho eona. O ka khetha lisele tsohle ka kholomong kapa mola, kapa esita le mofuta o ikhethileng. Ho khetha lethathamo la data, tobetsa sele ea pele ebe u tšoara konopo ea Shift ha u ntse u khetha sele ea ho qetela lethathamong.

Mohato oa 3: Sebelisa filthara

Ha u se u khethile lethathamo la data, e-ea ho "Data" menu ka holimo 'me u khethe khetho ea "Filter". U tla bona motsu o monyenyane o theohang o kenyelelitsoe selefounung ea pele ea mofuta o khethiloeng. Ho tobetsa motsu ona ho tla bula menu e tla u lumella ho etsa joalo lokisa maemo a ho batla ho kenya sefefo.

Mohato oa 4: Lokisa mokhoa oa ho batla

Ka har'a menu ea filthara, u ka khona lokisa maemo a ho batla ho latela⁢ litlhoko tsa hau. O ka sefa ka boleng bo ikhethileng, litaba tsa mongolo, matsatsi, mebala, le tse ling. Ho feta moo, o ka kopanya mekhoa e mengata ho ntlafatsa liphetho tsa hau ho ea pele.

Mohato oa 5: Laola liphetho tse tlhotliloeng

Hang ha u se u sebelisitse filtara, u ka khona laola liphetho tse tlhotliloeng ka litsela tse fapaneng. Ka mohlala, u ka kopitsa le ho beha feela liphetho tse tlhotliloeng ka har'a spreadsheet e ncha, ua li hatisa ka ho toba ho Google Sheets, kapa ua li romela ka mokhoa o mong oa faele. ⁢Sena se tla u lumella⁤ ho sebetsa ka lintlha tse tlhotliloeng hantle⁤ le ho etsa tlhahlobo e felletseng.

Ka mehato ena e bonolo, u ka khona kenya li-filters⁤ ho ⁢ Google​ Sheets ka katleho. Hore na o hloka ho hlophisa lintlha, ho etsa tlhahlobo, kapa ho fumana lintlha tse itseng, li-filters ho Google Sheets e tla ba sesebelisoa sa bohlokoa sa ho etsa hore mosebetsi oa hau o be bobebe ka li-spreadsheets. Joale, sebelisa tsebo ena. ⁢ 'me u sebelise tšobotsi ena e molemo ka ho fetisisa!

- Kenyelletso ea li-filters ho Google Sheets

Lisefe ho Google Sheets Ke sesebelisoa sa mantlha sa ho etsa tlhahlobo le ho qhekella data ho spreadsheet. Li-filters li u lumella ho khetha le ho bonts'a data feela e lumellanang le litekanyetso tse ikhethileng, e leng ho nolofalletsang ho sebetsa ka tlhahisoleseling e ngata. Ka li-filters, u ka hlophisa lintlha, ua li sefa ka mefuta ea boleng, u bonts'a boleng bo le bong kapa ua kopanya. mekhoa e mengata ea ho batla ka nepo.

Kenya lihloela ho Google Sheets E bonolo haholo. Pele, khetha litšiea tseo u batlang ho li sefa. Ebe u ea ho "Data" ka holimo ho spreadsheet ebe o tobetsa "Filter". U tla bona metsu e nyane⁤ e hlaha kaholimo ho kholomo e 'ngoe le e' ngoe e khethiloeng⁢. ⁤Ka ⁢ ho tobetsa ho e 'ngoe ea metsu ena, ho tla hlahisoa lenane le nang le likhetho tse fapaneng tsa ho sefa.

El filthara ya motheo e o lumella ho khetha⁢ litekanyetso tse ikhethileng tseo u ka li bonts'ang kapa ho li pata. U ka sefa ka linomoro, ⁢ mongolo, matsatsi⁢ kapa ua siea feela boleng bo se na letho. Ho feta moo, o ka sebelisa sesebelisoa hloeki e tsoetseng pele, e leng se u lumellang hore u kopane litekanyetso tse 'maloa le ho etsa lipatlisiso tse rarahaneng. U ka sefa ka maemo a mangata u sebelisa "le"⁣ kapa "kapa", ho u fa bonolo haholoanyane tlhahlobisong ea hau ea data. U ka boloka lihloela tsa hau ho li sebelisa hape nakong e tlang.

Ka kakaretso, Li-filters ho—Google Sheets ke sesebelisoa se matla sa ho sebetsa ka data ho a⁢ spreadsheet. Li u lumella ho khetha le ho bonts'a data feela e lumellanang le litekanyetso tse itseng, ho hlopha le ho sefa ka mefuta ea boleng, ho bonts'a boleng bo le bong, kapa ho etsa lipatlisiso tse rarahaneng ka li-filters tse tsoetseng pele. Ho ithuta ho sebelisa li-filters ho Google Sheets ho tla u thusa ho boloka nako le ho fumana lintlha tse bohlokoa le tse nepahetseng ho tsoa ho. lintlha tsa hau. Leka tšobotsi ena 'me u rue molemo ka ho fetisisa ho spreadsheet ea hau!

- Mohato ka mohato⁤ ho kenya lihloela ho Google ⁤Sheets

Ho sebelisa li-filters ho Google Sheets ke ka katleho ho hlophisa le ⁢ho sekaseka data ho ⁢spreadsheet. Ka tšobotsi ena, u ka khetha le ho hlahisa feela data eo u e ratang, e u lumellang hore u sebetse ka mokhoa o atlehileng haholoanyane. Mona ke mokhoa o bonolo ⁢ mohato ka mohato oo u ka ithutang ho sebelisa li-filters⁢ ho Google Sheets .

Mohato oa 1: ⁢Bula spreadsheet ho Google Sheets ebe u khetha lisele tseo u batlang ho li sefa. U ka khetha kholomo kaofela, likholomo tse ngata tse bapileng, kapa mefuta e itseng ea lisele.

Mohato oa 2: Ho menu e ka holimo, tobetsa "Lintlha" ebe o khetha⁢ «Filtro». Sena se tla bula menyetla e theohang moleng oa lihlooho tsa spreadsheet ea hau.

Mohato oa 3: Moleng oa lihlooho, u tla bona motsu o monyane tlase seleng ka 'ngoe. Tobetsa motsu oa kholomo eo u batlang ho sefa ka eona 'me lethathamo la maemo le tla hlahisoa ka likhetho tse fapaneng tse fumanehang.

Joale u se u itokiselitse ho sebelisa li-filters tse lumellanang hantle le litlhoko tsa hau. ⁤O ka sefa datha ho ya ka mefuta, boleng bo ikgethileng, ho beakanya maemo, kapa esita le ho etsa difilthara tse ntlafetseng. Ka ho sebedisa difilthara ho Google Sheets, o ka nolofatsa ho boha le ho sekaseka datha tsa hao, wa boloka nako le ho etsa hore ho be bonolo ho nka boitsebiso. .

- Mokhoa oa ho sebelisa mokhoa oa ho sefa ho Google Sheets

Mokhoa oa ho sebelisa mokhoa oa ho sefa ho Google Sheets

Ho Google Sheets, li-filters ke sesebelisoa se matla se u lumellang ho sekaseka le ho sheba data ea spreadsheet ka ho hlaka. Ka mokhoa oa ho sefa, o ka tsepamisa maikutlo ho karolo e nyane ea data e fihlelang maemo a itseng. Ho sebelisa mokhoa oa ho hloekisa ho Google Sheets, latela mehato ena:

1. Khetha mofuta oa data: Pele o sebelisa filthara, o tlameha ho khetha mefuta e fapaneng ea data eo o batlang ho e sebelisa ho eona. U ka etsa sena ka ho tobetsa seleng e kaholimo ho le letšehali la lethathamo la data, u tšoare konopo ea mouse ebe u e hulela ka tlase ho sele e ka tlase ho le letona.

2. Kenya sefe⁢ sefe: Hang⁤ ha u se u khethile mofuta oa data, e ea ho "Data" ka holimo⁤ fensetereng ea Google Sheets. ⁤Ebe, ⁤khetha khetho ea "Filter" ho tsoa ho menu e theoha. Sena se tla etsa hore metsu e menyane e hlahelle kaholimo ho kholumo ka 'ngoe lethathamong la hau la data.

3. Iketsetse mokhoa oa ho hloekisa: Kaha joale u se u sebelisitse filthara, u ka etsa mekhoa ea hau ea ho sefa data ho latela litlhoko tsa hau. Tobetsa motsu oa sefe holim'a kholomo eo u batlang ho e sefa ebe u khetha lintlha tse lakatsehang lethathamong le theolelang. U ka khetha likhetho tse kang "custom text," "number," kapa "date." U ka boela ua kenya mekhoa ea hau ea tloaelo.

Ho sebelisa mokhoa oa ho hloekisa ho Google Sheets ho u lumella ho sekaseka lintlha tsa hau ka tsela e nepahetseng le e sebetsang hantle. Hopola hore o ka ⁢sebelisa lihloela tse ngata ka nako e le ngoe ho fumana ⁢le leseli le felletseng. Tseba karolo ena 'me u rue molemo ka ho fetisisa ho li-spreadsheet tsa hau ka Google Sheets!

- Malebela a ho eketsa ts'ebetso ha o sebelisa lifilimi ho Google Sheets

Ha u sebelisa Google Sheets, e 'ngoe ea lisebelisoa tse molemo ka ho fetisisa ke bokhoni ba ho sebelisa li-filters ho data ea rona. Lisefe li re fa monyetla oa ho hlophisa le ho bona tlhahisoleseling ka nepo, e leng ho nolofaletsang ho e sekaseka le ho etsa liqeto. Ka mor'a moo, re tla u fa malebela a ho eketsa ts'ebetso e nepahetseng ha u sebelisa lihloela ho Google Sheets.

Sebelisa li-filters tse tsoetseng pele: Google Sheets e re fa monyetla oa ho sebelisa li-filters tsa mantlha, empa haeba re batla ho fumana liphetho tse nepahetseng haholoanyane, ho eletsoa ho sebelisa lihloela tse tsoetseng pele. Lisefe tsena li re lumella ho kopanya mekhoa le maemo a mangata⁤ ho⁢ ho fumana⁢ liphetho tse hlakileng haholoanyane. Ho fihlella li-filters tse tsoetseng pele, o tlameha ho khetha data e tla tlhotloa ebe u ea ho "Data" tab ea toolbar. Ha u le moo u tla fumana khetho ea "Create an advanced filter" e tla u lumella hore u iketsetse mekhoa ea hau ea ho sefa.

Nolofatsa mokhoa oa hau oa ho batla: Ha u sebelisa li-filters, ho bohlokoa ho hopola hore ha re ntse re eketsa litekanyetso, mokhoa oa ho sefa o ba thata haholoanyane 'me o ka nka nako e telele hore o phethe. Ka hona, ho bohlokoa ho nolofatsa ts'ebetso ka ho sebelisa mekhoa e hlokahalang feela le ho tlosa tse sa hlokahaleng. Sena se tla re lumella ho boloka nako le ho fumana liphetho tse nepahetseng ka potlako. Hopola ho boloka maemo a ho sefa a le bonolo kamoo ho ka khonehang ho qoba pherekano le ho fumana liphetho tse lakatsehang.

Boloka ⁤ 'me u sebelise lihloela tse iketselitsoeng: ⁤Haeba u sebelisa mokhoa o ts'oanang oa ho sefa khafetsa, u ka boloka nako ho theha le ho boloka lihloela tsa tloaelo. Hang ha u se u sebelisitse mokhoa oo u o batlang oa ho sefa, khetha khetho ea "Save as Filter" ho "Data" ea toolbar. Sena se tla u lumella ho fihlella ka potlako li-filters tsa hau nakong e tlang 'me u li sebelise ho lihlopha tse fapaneng tsa data. ⁢Ho feta moo, o ka bolela le ho hlophisa lifilthara tsa hau tsa tloaelo⁢ bakeng sa taolo e betere le phihlello ho tsona. Karolo ena e bohlokoa haholo haeba o sebetsa le li-spreadsheet khafetsa mme o hloka ho sebelisa li-filters tse tšoanang khafetsa.

- Mokhoa oa ho kopanya le ho kopanya lifilimi ho Google Sheets

Ha o sebetsa ka data ho Google Sheets, ho bohlokoa ho tseba ho sebelisa le ho kopanya li-filters ho ntlafatsa pono le tlhahlobo ea tlhaiso-leseling. Lisefe ho Google Sheets li u fa monyetla oa ho sefa datha ho latela maemo a ikhethileng, joalo ka ho khetha feela boleng bo fetang palo e itseng kapa ho hlahisa mela e nang le mantsoe a itseng feela. Ho feta moo, re ka kopanya ⁢ lihloela tse 'maloa ho fumana liphetho tse nepahetseng.

Ho sebelisa sefe⁤ ho Google Sheets, re tlameha feela ho khetha kholomo kapa lethathamo la data ho sefa ebe o tobetsa ho ‌»Data» ⁢ho bareng ea menyu e holimo. Ka mor'a moo, re khetha khetho ea "Filter" 'me lethathamo la ho theoha le tla etsoa ka mokhoa o itekanetseng moleng oa pele oa kholomo e' ngoe le e 'ngoe e khethiloeng. Lethathamong lena, re ka khetha ⁤mekhahlelo e lakatsehang ea ho sefa, joalo ka ⁤ boleng bo ikhethileng, matsatsi, mongolo, joalo-joalo. Hape re ka sebelisa ts'ebetso ea ho batla ho fumana boleng bo itseng ka har'a lenane le theoha.

Ho kopanya lihloela ho Google Sheets, re ka sebelisa lisebelisoa tse utloahalang⁢ joalo ka "AND" le "OR". Ka mohlala, haeba re batla ho sefa ⁢data⁤ e finyellang litekanyetso tse peli ka nako e le 'ngoe, re sebelisa mochine oa «AND». Ka lehlakoreng le leng, ⁢haeba re batla ho sefa data e ⁤e kopanang le bonyane e le 'ngoe ea lipehelo tse peli, re sebelisa⁣ "OR". Ho kopanya filthara⁤, re sebelisa sefe ea pele feela ka ho tobetsa lenane le theolelang la kholomo e tsamaellanang le ho kenya filthara ea bobeli re sebelisa opareitara e utloahalang kholomong e tšoanang kapa kholomong e haufi.

Ntle le ho kopanya li-filters tse bonolo, hoa khoneha ho kopanya li-filters tse 'maloa tse rarahaneng ho etsa litlhahlobo tse tsoetseng pele. Sena se re fa monyetla oa ho sefa datha ka nepo le ho fumana lintlha tse ikhethileng ho tsoa setsing sa rona sa data. Ka ho kopanya le ho bapisa lihloela ho Google Sheets, re ka fumana likarabo tsa lipotso tse rarahaneng le ho fihlela liqeto tse amanang le mosebetsi kapa morero oa rona. Hopola hore kamehla hoa khoneha ho hlophisa kapa ho hlakola lihloela tse sebelisitsoeng ebe u khutlela ho sete ea data ea mantlha.

- Ho sebelisa liforomo tsa tloaelo ho sefa data ho Google Sheets

Lipampiri tsa Google Ke sesebelisoa se sebetsang haholo bakeng sa ho hlophisa le ho sekaseka data. E 'ngoe ea likarolo tsa bohlokoa tseo e fanang ka tsona ke bokhoni ba ho sebelisa li-filters ho lihlopha tse fapaneng tsa data. Ha u sebelisa mekhoa e tloaelehileng Ho sefa data ho Google Sheets, o ka fumana liphetho tse hlakileng le tse hlakileng haholoanyane. Ka mor'a moo, re tla u bontša hore na u ka sebelisa lihloela joang u sebelisa mekhoa e iketselitsoeng ho Google Sheets.

1. Iketsetse ⁤formula e ikhethileng: Ho Google Sheets, u ka khona ⁢ ho iketsetsa liforomo tsa hau tsa tloaelo u sebelisa puo ea lenaneo Google Apps Script. Sena se o lumella ho sefa datha ho latela mekhoa e fapaneng e ikhethileng. Mohlala, o ka etsa foromo e hloekisang data ho latela letsatsi le itseng, palo e fapaneng ea linomoro, kapa mantsoe a bohlokoa a ngotsoeng .

2. Sebelisa foromo e tloahelehileng lethathamong la data: Ha u se u iketselitse foromo ea hau ea tloaelo, u tlameha ho e sebelisa lethathamong la lintlha tseo u batlang ho sefa ho tsona. U ka etsa sena ka ho khetha mefuta e mengata ea lisele ho Google Sheets ebe o sebelisa ts'ebetso filterRange ka foromong ea hau e ikhethileng.

3. Ntlafatsa liphetho tsa sefe: Ha u se u sebelisitse mokhoa o ikhethileng molemong oa data, liphetho tsa sefe li tla intlafatsa. ⁣Sena se bolela hore ha o ka fetola boleng ba mofuta ofe kapa ofe ⁤ lethathamong la data la mantlha,⁤ liphetho tsa sefe li tla lokisoa ka nepo. ⁤Ho etsa bonnete ba hore liphetho tsa sefa li nchafatsoa ka nepo, ho bohlokoa ho etsa bonnete ba hore foromo ea hau ea tloaelo e ngotsoe ka nepo le ka nepo kamoo ho ka khonehang.

Sebelisa mekhoa e tloaelehileng ho sefa data ho Google Lipampiri li ka ba a ka katleho ho fumana lintlha tse nepahetseng le tse nepahetseng haholoanyane. Ka tsebo e nyane ea Sengoloa sa Google Apps, u ka iketsetsa liforomo tse lumellanang le litlhoko tsa hau tse ikhethileng. Leka ka mekhoa e fapaneng ea ho sefa 'me u fumane hore na u ka sebelisa sesebelisoa sena se matla sa spreadsheet joang.

- Mokhoa oa ho boloka le ho arolelana lihloela⁢ ho Google Sheets

Mokhoa oa ho boloka le ho arolelana lifilimi ho Google Sheets

Guardar filtros
Ho boloka nako ⁢le ho nolofatsa ho sebetsa ho ⁤Google Sheets, ho a khonahala boloka disefe meetlo e sebedisoang ho spreadsheet. ⁢Hang ha filthara e se e hlophisitsoe ho latela maemo a lakatsehang, u tlameha feela ho khetha ⁢khetho ea "Save Current Filter" ⁢ho menu ea "Data". Joale u ka fana ka lebitso la botsoalle ho sefa ebe u boloka. Ka tsela ena, sefahla seo se ka fihlelleha ka nako efe kapa efe ntle le ho se hlophisa hape. Ho feta moo, li-filters tse ngata li ka bolokoa le ho fetoloa lipakeng tsa tsona ha ho hlokahala.

Arolelana lihloela
Maemong a mangata, hoa hlokahala arolelana li-filters e sebelisoa ho Google Sheets le basebetsi-mmoho kapa bathusi. Ka lehlohonolo, sena se bonolo haholo⁢ ho⁤ ho se etsa. Hang ha filthara e se e bolokoa, u ka ea ho "Data" menu ebe u khetha "Laola li-filters." Ha u le moo, u fumana lihloela tsohle tsa hau tse bolokiloeng, 'me u ka khona ho arolelana sefa se ikhethileng ka ho tobetsa letšoao la "Share" haufi le lona. Ho etsa joalo ho tla hlahisa sehokelo se ka romelloang ho mang kapa mang ea nang le phihlello ea spreadsheet. Ha baamoheli ba bula sehokelo, ba tla khona ho sheba le ho sebelisa filthara e arolelanoang likoping tsa bona tsa spreadsheet.

Tlosa li-filters
Haeba ka nako efe kapa efe u lakatsa tlosa⁢ sefa e bolokiloe ho Google Sheets, u tlameha feela ho ea ho "Data" menu ebe u khetha ⁢»Laola⁤ lihloela». Ha u le moo, u ka bona li-filters tsohle tse bolokiloeng, 'me haufi le e' ngoe le e 'ngoe ea tsona, ho hlaha letšoao la "Delete". Ho tobetsa aekhone eo ho tla tlosa sefe ka ho sa feleng 'me ha ho sa tla ba teng.

Nka monyetla oa likarolo tsena ho Google Sheets ho laola le ho arolelana lihloela ka nepo le ka kopanelo ho li-spreadsheets tsa hau!

- Ho rarolla mathata a tloaelehileng ha u sebelisa li-filters ho Google Sheets