Ukushintsha phakathi kwamashidi e-Excel. Ama-hotkeys

Ngokuvamile, abasebenzisi bomhleli wespredishithi badinga ukwenza inqubo yokushintsha phakathi kwamashidi. Kunezindlela eziningi zokwenza le nqubo elula. Lesi senzo kufanele sikwazi ukwenza ezimeni lapho idokhumenti yesipredishithi iqukethe inani elikhulu lamakhasi okusebenza. Izindlela zokushintsha zihlanganisa: ukusebenzisa izinhlanganisela ezikhethekile ze-hotkey, ukusebenzisa ibha yokuskrola, nokuzulazula usebenzisa izixhumanisi. Esihlokweni, sizohlaziya ngayinye yezindlela ngokuningiliziwe.

Indlela Yokuqala: Ukusebenzisa Okhiye Abakhethekile

Ama-hotkeys akuvumela ukuthi usebenzise ngokushesha izenzo ezahlukahlukene kusihleli sespredishithi. Ukuze usebenzise ukushintsha phakathi kwamakhasi okusebenza, izinhlanganisela ezimbili zokhiye oshisayo zisetshenziswa:

• Inhlanganisela yokuqala: “Ctrl + Page Up”.
• Inhlanganisela yesibili: “Ctrl + Page Down”.

Lezi zinhlanganisela ezimbili zihlinzeka ngoshintsho olusheshayo phakathi kwamakhasi okusebenzela edokhumenti yesipredishithi ishidi elilodwa emuva noma phambili.

Le ndlela ifaneleka kakhulu ezimweni lapho incwadi yedokhumenti iqukethe inani elincane lamakhasi okusebenza. Kuhle futhi ekusebenzeni ngamashidi aseduze wedokhumenti yesipredishithi.

Indlela Yesibili: Ukusebenzisa Ibha Yokuskrola Ngokwezifiso

Le ndlela kuhle ukuyisebenzisa uma idokhumenti yesipredishithi iqukethe inani elikhulu lamakhasi okusebenza. Iqiniso liwukuthi uma kunamashidi amaningi efayeleni, khona-ke ukusetshenziswa kokhiye oshisayo okhethekile kuzothatha isikhathi esiningi somsebenzisi. Ngakho-ke, ukuze wonge isikhathi kakhulu, udinga ukusebenzisa ibha yokuskrola etholakala ezansi kwesixhumi esibonakalayo somhleli wespredishithi se-Excel. Umyalelo onemininingwane wokushintsha amashidi usebenzisa ibha yokuskrola ubukeka kanje:

1. Sithuthela phansi kwesixhumi esibonakalayo somhleli wethebula. Sithola lapha ibha yokuskrola ekhethekile.
2. Chofoza ibha yokuskrola ngenkinobho yegundane engakwesokudla.
3. Isibonisi sibonise uhlu oluncane, olubonisa wonke amaphepha okusebenza edokhumenti yesipredishithi.
4. Sithola ishidi lokusebenzela esilidingayo bese sichofoza kulo LMB.

5. Ilungile! Senze ukushintsha phakathi kwamakhasi okusebenzela edokhumenti yesipredishithi sisebenzisa ibha yokuskrola.

Indlela Yesithathu: Ukusebenzisa Izixhumanisi Kumbhalo Wespreadsheet

Le ndlela enzima ihlanganisa ukwakhiwa kwephepha lokusebenzela elengeziwe elisizayo, elizoqukatha ithebula lokuqukethwe, elisetshenziswa kusetshenziswa ama-hyperlink akhethekile. Lezi zixhumanisi zizoqondisa kabusha umsebenzisi kumakhasi okusebenza adingekayo edokhumenti yesipredishithi.

Le ndlela iqukethe amafomula okudala ama-hyperlink. Uhlu lwama-hyperlink lwenziwa kusetshenziswa i-GET.WORKBOOK opharetha. Imiyalelo enemininingwane ibukeka kanje:

1. Okokuqala, sithuthela "Isiphathi Segama". Sithuthela esigatshaneni esithi "Amafomula", sithola ibhulokhi elithi "Amagama achaziwe" bese sifaka igama elisha lapho, isibonelo, "Uhlu_ lwamashidi". Emugqeni othi “Ububanzi:" faka ifomula elandelayo: =FAKA INDAWO(THOLA.INCWADI YOMSEBENZI(1),1,THOLA(“]”,THOLA.INCWADI YOMSEBENZI(1)),””).

2. Ingasetshenziswa futhi njengefomula =THOLA.INCWADI YOMSEBENZI(1), kodwa amagama wamakhasi okusebenza nawo azoqukatha igama lencwadi (ngokwesibonelo, [Book1.xlsb]Sheet1).
3. Sisusa yonke idatha kuze kufike kubakaki besikwele sokuvala abangaphandle, ukuze ekugcineni kusale kuphela igama lephepha lokusebenzela elithi “Ishidi1”. Ukuze singasebenzisi le nqubo ngaso sonke isikhathi lapho sifinyelela izinto zokuhluka kwe-“List_sheets” sisebenzisa amafomula, sisebenzisa lesi sikhathi esingu-1 engxenyeni ngayinye.
4. Ngenxa yalokho, amagama awo wonke amashidi okusebenza edokhumenti yesipredishithi atholakala kokuhluka okusha okudaliwe okuthi “LIST_SHEETS”. Ngamanye amazwi, sithole uhlu olukhethekile olunamanani. Sidinga ukukhipha lawa magugu.
5. Ukuze usebenzise le nqubo, kufanele usebenzise opharetha okhethekile we-INDEX, okuvumela ukuthi ubuyise into yamalungu afanayo ngenombolo ye-serial. Ukwengeza, sisebenzisa umsebenzisi okuthiwa STRING ukuze sakhe izinombolo ezivamile.

6. Esigabeni esilandelayo, ukuze sakhe ukuzulazula okunethezeke kakhudlwana, sisebenzisa i-opharetha ye-HYPERLINK. Sizosebenzisa inqubo yokwengeza izixhumanisi emagameni wamakhasi okusebenza.

7. Ekugcineni, zonke izixhumanisi zizoqondisa kabusha kuseli A1, elihambisana negama lephepha lokusebenzela ledokhumenti yesipredishithi.

Ngaphezu kwalokho, ungakha ishidi elinama-hyperlink usebenzisa ulimi oludidiyelwe lokuhlela VBA.

Imiyalelo enemininingwane ibukeka kanje:

1. Cindezela inhlanganisela yokhiye "Alt + F11".
2. Sakha imojuli entsha.
3. Faka ikhodi elandelayo lapho:

   Uhlu Lweshidi Lokusebenza(N Njengenani eliphelele)

   Uhlu Lweshidi = I-ActiveWorkbook.Amashidi okusebenza(N).Igama

   Qeda Umsebenzi.

4. Sibuyela endaweni yokusebenzela, sisebenzisa uhlelo oludaliwe, sisebenzisa ukudalwa kohlu lwamaphepha okusebenza amadokhumenti. Ukwenza lokhu, njengakusibonelo esingenhla, sisebenzisa i-ROW opharetha ukwakha izinombolo ezivamile.

5. Senza ukuphindaphinda kokwengeza izixhumanisi.

6. Ilungile! Sakhe ishidi elikuvumela ukuthi ushintshe ngokushesha phakathi kwamakhasi okusebenza kudokhumenti yesipredishithi.

Isiphetho neziphetho kanye nokushintsha phakathi kwamakhasi okusebenzela

Sithole ukuthi ziningi izindlela ezikuvumela ukuthi ushintshe phakathi kwamakhasi okusebenzela kudokhumenti yesipredishithi. Ungakwazi ukwenza lesi senzo usebenzisa okhiye abashisayo abakhethekile, amabha okuskrola, nokudala izixhumanisi. Ama-hotkeys ayindlela elula yokushintsha, kodwa ayifanele ukusebenza ngenani elikhulu lolwazi. Uma idokhumenti yesipredishithi iqukethe inani elikhulu ledatha yethebula, kufaneleke kakhulu ukusebenzisa ukudalwa kwezixhumanisi, kanye namabha okuskrola.