Ka tloaelo, lisele tse nang le litlhaloso ho Excel le Google Sheets li bontša likarabo tsa mekhoa eohle le mesebetsi e teng leqepheng la mosebetsi .
Ka maqephe a maholo a maqephe, ho tobetsa ho potoloha ka pointer ea mouse ho fumana lisele tse nang le litlhaloso tsena kapa mesebetsi e ka ba ho otloa kapa ho fofa mosebetsing.
Bontša liforomo tsa Excel le Google Sheets Ho Sebelisa Litsela tsa Shortcut
Tlosa boikarabello ha u fumana lihlahisoa ka ho sebelisa motsoako oa khetho ea khetho ho bontša litlhahlobo tsohle Excel le Google Sheets:
Ctrl + `(key key accent)
Linthong tse ling tse tloaelehileng tsa keyboards, konopo ea molumo oa lebitla e fumanehile haufi le senotlolo sa nomoro ka holimo se ka holimo le letšehali la lebokose. E shebahala joaloka apostrophe ea morao.
Kopano ena ea bohlokoa e sebetsa e le senotlolo sa ho fetola, e leng se bolelang hore o hatella moelelo o le mong hape bakeng sa ho pata liforomo ha o qetile ho li shebella.
Mehato ea ho Bontša Litlhahlobo Tsohle
- Tlanya le ho thibela konopo ea Ctrl lebokoseng.
- Tlanya le ho lokolla konopo ea molumo oa lebitla ka lebokose ntle le ho lokolla senotlolo sa Ctrl.
- Lokolla senotlolo sa Ctrl .
Lethathamo la lipampiri le lokela ho bonts'a litlhaloso tsohle tsa lisele tsa bona tsa lipampiri ho e-na le liphello tsa foromo.
Ho Nchafatsa Litlhahlobo
Ho bonts'a liphello hape ho e-na le litlhaloso, tobetsa hape linotlolo tsa Ctrl + ` .
Mabapi le Bontša Litlhahlobo
- Bontša lihlahisoa ha li fetole litaba tsa lipampiri, feela kamoo li bontšitsoeng kateng.
- Bontša lihlahisoa tse etsang hore ho be bonolo ho fumana lisele tse nang le litlhaloso.
- E nolofalletsa ho bala ka potlako mekhoa eohle ho hlahloba liphoso.
- Karolo ena e ka boela ea etsoa ka ho khetha:
- Litlhahlobo > Bontša liforomo holim'a Ribbon e Excel
- Sheba > Kgetho eohle ea Formulas menoong a Li-Google Sheet
- Litokomane tsa ho hatisa le Lipontšo tsa Lipontšo li buloa li ka nolofalletsa ho batla ka thata ho fumana liphoso.
Bontša Lifomane tsa Mosebetsi oa Boipheliso
Ho e-na le ho sheba litlhahlobo tsohle, ho ka khoneha ho sheba liforomo ka lekhetlo le le leng feela ka:
- Ho penya habeli seleng e nang le foromo le mouse.
- Ho tobetsa hanngoe ka seleng e nang le foromo ka mouse mme ebe o hatella key F2 lebokoseng.
Mesebetsi ena ka bobeli e beha lenaneo-ebang ke Excel kapa Google Sheet-ho fetola mokhoa oa ho fetola, o bontsang foromo ka seleng le ho hlahisa mebala e hlalositsoeng ka selefouno e sebelisoang ka mokhoa ona. Sena se etsa hore ho be bonolo ho fumana mehloli ea data e sebelisetsoang foromong.
Pata Lipampiri ho Excel Sebelisa Lethathamo la Tšireletso
Kgetho e 'ngoe ea ho pata liforomo ka Excel ke ho sebelisa tšireletso ea lipampiri , e kenyeletsang khetho ea ho thibela liforomo ka lisele tse koetsoeng ho tloha ho li bonts'oa libakeng tsena:
- Ka seleng moo ba leng teng
- Sebakeng sa thepa ha sele e nang le foromo e tobetsoe
- Ha Lipontšo tsa Lipontšo li sebelisoa ho sebelisoa tsela e khutšoanyane ea li-keyboard kapa ka har'a libone.
Ho pata liforomo, joaloka lisele tse koaletsoeng, ke mehato e 'meli e kenyelletsang ho khetholla lisele tsa lisele tseo u li patang ebe o sebelisa tšireletso ea mosebetsi.
Khetha Selekane sa Cell ho Pata
- Khetha mofuta oa lisele tse nang le litlhaloso tse lokelang ho patoa.
- Tabeng ea Lehae ea Lehae , tobetsa Setomane sa Fomati ho bula menu e theoha.
- Lenaneng, tobetsa ho Fumana Lisele tsa ho bulela lebokose la boitsebiso la lihlooho tsa Format.
- Ka lebokoseng la lebokose, tobetsa Thabiso ea Tšireletso .
- Tabeng ena, khetha lebokose le reng le patiloeng .
- Tobetsa OK ho sebelisa phetoho le ho koala lebokose la lebokose.
Etsa Kopo ea Sesebelisoa sa Mosebetsi
- Tabeng ea lehae la Ribbon, tobetsa ho Khethoa ho khetha ho bula menu e theoha.
- Tobetsa ho Sireletsa Sheet sekhetho tlasa lethathamong la ho bula lebokose la lebokose la Tšireletso ea Leqephe.
- Sheba kapa u se ke ua hlokomoloha khetho eo ue batlang.
- Tobetsa OK ho sebelisa liphetoho le ho koala lebokose la lebokose.
Ka nako ena, liforomo tse khethiloeng li lokela ho patoa ho tloha ponong ea bar. Ho fihlela mohato oa bobeli o ntse o etsoa, mekhoa e ntse e bonahala ho seleng ea lipampiri le baroleng ea foromo.