Haeba u sebelisa Microsoft Excel khafetsa, mohlomong u hlokometse hore ho fetola lipampiri tse fapaneng ho Excel ho thata haholo. Ka linako tse ling ho fetola pakeng tsa maqephe a seng makae a mosebetsi ho bonahala ho le bonolo. Mokhoa o atileng haholo oa ho fetola li-tab ke ho tobetsa konopo ka 'ngoe. Leha ho le joalo, ha ho tluoa tabeng ea ho laola maqephe a mangata a mosebetsi ho Excel e le 'ngoe, ke mosebetsi o boima haholo. Ka hona, ho ba le tsebo ka likhutšoane le linotlolo tse khutšoane ho tla ba molemo haholo. 'Me likhutšoane tsena li ka u thusa ho eketsa tlhahiso ea hau. A re tšohleng mekhoa eo u ka e sebelisang switjha habonolo lipakeng tsa lipampiri tse fapaneng ho Excel e le 'ngoe.
Ho sebelisa linotlolo tse khaoletsang ha ho etse hore u be botsoa empa ho eketsa tlhahiso ea hau le ho u bolokela nako e ngata eo u ka e qetang mosebetsing o mong. Ka linako tse ling, touchpad ea hau kapa toeba e emisitse ho sebetsa 'me boemong boo, likheo tsa keyboard li tla ba bonolo haholo. Ka hona, Likhaoletso tsa Excel ke litsela tse molemo ka ho fetisisa tsa ho potlakisa mosebetsi oa hau.
Litaba[ pata ]
- Fetola ka Potlako lipakeng tsa Lipampiri tsa Mosebetsi ho Excel
- Mokhoa oa 1: Linotlolo tsa Shortcut ho chencha lipakeng tsa Worksheets ho Excel
- Mokhoa oa 2: Eya ho Taelo ho potoloha maqephe a mosebetsi a excel
- Mokhoa oa 3: Suthela leqepheng le fapaneng la mosebetsi u sebelisa Ctrl + Left Key
Fetola ka Potlako lipakeng tsa Lipampiri tsa Mosebetsi ho Excel
Mokhoa oa 1: Linotlolo tsa Shortcut ho chencha lipakeng tsa Worksheets ho Excel
Ctrl + PgUp (leqephe holimo) - Tsamaisetsa leqephe le le leng ka ho le letšehali.
Ha u batla ho ea ka ho le letšehali:
1. Tobetsa o hatelle konopo ea Ctrl keyboard.
2. Tobetsa le ho lokolla konopo ea PgUp keyboard.
3. Ho isa leqephe le leng letsohong le letšehali ebe o lokolla konopo ea PgUp khetlo la bobeli.
Ctrl + PgDn (leqephe tlase) - Tsamaisa leqephe le le leng ho le letona.
Ha u batla ho ea ka ho le letona:
1. Tobetsa o hatelle konopo ea Ctrl keyboard.
2. Tobetsa le ho lokolla konopo ea PgDn keyboard.
3. Ho fallela leqepheng le leng ho tobetsa le letona ebe o lokolla konopo ea PgDn lekhetlo la bobeli.
Hape Bala: Faele ea XLSX ke eng & Mokhoa oa ho bula XLSX File?
Mokhoa oa 2: Eya ho Taelo ho potoloha maqephe a mosebetsi a excel
Haeba u na le leqephe la Excel le nang le data e ngata, Go To command e ka u thusa ho ea liseleng tse fapaneng. Ha e na thuso bakeng sa maqephe a mosebetsi a nang le palo e tlase haholo ea data. Ka hona, ho eletsoa ho sebelisa taelo ena hafeela u e-na le faele ea Excel e nang le palo e kholo ea data.
Mohato oa 1: Tsamaea ho ea ho Fetola khetho ea menu.
Mohato oa 2: Tobetsa ho Fumana & Khetha khetho ebe u khetha ea Eya Ho Khetho.
Mohato oa 3: Mona ngola referense moo u batlang ho ea teng: Sheet_name + lets'oao la mohoo + referense ea sele.
Ela hloko: Ka mohlala, haeba ho na le Leqephe la 1, Leqephe la2, le Leqephe3, joale ho referense u hloka ho ngola lebitso la leqephe leo u batlang ho ea ho lona ebe referense ea sele. Kahoo haeba u hloka ho ea leqepheng la 3 joale thaepa Letlapa3!A1 moo A1 e leng sesupo sa sele ho Leqephe la 3.
Mohato 4: Joale tobetsa OK kapa tobetsa Kenya senotlolo ka har'a keyboard.
Mokhoa oa 3: Suthela leqepheng le fapaneng la mosebetsi u sebelisa Ctrl + Left Key
Ka mokhoa ona, o tla fumana lebokose la lipuisano le nang le maqephe ohle a fumanehang ho excel ea hau ho fetola lipakeng. Mona o ka khetha habonolo leqephe la mosebetsi leo u batlang ho sebetsa ho lona. Ona ke mokhoa o mong oo u ka khethang ho o fetola lipakeng tsa maqephe a sebetsang a teng faeleng ea hau ea hajoale ea Excel.
Ho na le likhutšoane tse ling tse 'maloa tsa Excel tse ka u thusang ho etsa lintho tsa hau ka Excel ka tsela e bonolo le e potlakileng.
CTRL +; Ka sena, o ka Kenya letsatsi la hajoale ka har'a sele e sebetsang
CTRL + A E tla khetha leqephe lohle la mosebetsi
ALT + F1 E tla theha chate ea data sebakeng sa hajoale
SHIFT + F3 Ka ho tobetsa sekhechana sena, se tla hlaha lebokose la puisano la Insert Function
SHIFT + F11 E tla kenya leqephe le lecha la mosebetsi
CTRL + HOME U ka fallela qalong ea leqephe la mosebetsi
CTRL + SPACEBAR E tla khetha kholomo eohle leqepheng la mosebetsi
SHIFT + SPACEBAR Ka sena, o ka khetha mola oohle leqepheng la mosebetsi
Na ho bohlokoa ho khetha linotlolo tse khaoletsang tsa ho sebetsa ho Excel?
Hape Bala : Lokisa Excel e emetse sesebelisoa se seng ho phethela ketso ea OLE
Na u batla ho lula u ntse u phetla le ho tobetsa maqephe a mosebetsi letsatsi lohle kapa u batla ho etsa mosebetsi oa hau kapele le ho qeta nako e itseng ea boleng le lithaka tsa hau le basebetsi-'moho? Haeba u batla ho etsa lintho tsa hau kapele, li-shortcuts tsa Excel ke tsela e ntle ea ho etsa sena. Ho na le likhutšoane tse ling tse ngata tse fumanehang bakeng sa mesebetsi e fapaneng ho Excel, haeba u ka li hopola kaofela, e tla u etsa mohale ea phahameng ho Excel. Leha ho le joalo, u ka hopola feela likhutšoane tseo u li sebelisang khafetsa mosebetsing oa hau kaha li tla u thusa ho etsa mesebetsi ea hau ea letsatsi le letsatsi kapele.
Elon Decker Elon ke sengoli sa thekenoloji ho Cyber S. O se a ntse a ngola litataiso tsa mokhoa oa ho etsa lilemo tse ka bang 6 joale mme o akaretsa lihlooho tse ngata. O rata ho bua ka lihlooho tse amanang le Windows, Android, le maqheka le malebela a morao-rao.