Ukushintsha okusheshayo phakathi kwamashidi

Ingabe unawo amafayela anamashidi amaningi? Kuningi ngempela - ishumi nambili? Ukuya eshidini elingakwesokudla encwadini enjalo kungacasula - uze uthole ithebhu yeshidi elifanele, uze uchofoze kulo ...

Indlela 1. Ama-hotkeys

Inhlanganisela Ctrl+PgUp и Ctrl+PgDown ikuvumela ukuthi uphenye ngokushesha incwadi yakho uye phambili naphambili.

Indlela 2. Ukuguqulwa kwegundane

Chofoza nje okulungile chofoza izinkinobho zokuskrola kwesokunxele samathebhu weshidi bese ukhetha ishidi olifunayo:

Ukushintsha okusheshayo phakathi kwamashidi

Ilula futhi nenhle. Isebenza kuzo zonke izinguqulo ze-Excel.

Indlela 3. Uhlu lokuqukethwe

Le ndlela inzima, kodwa yinhle. Ingqikithi yalo ukwakha ishidi elikhethekile elinezixhumanisi eziholela kwamanye amashidi encwadi yakho futhi ulisebenzise njengethebula "bukhoma" lokuqukethwe.

Faka ishidi elingenalutho encwadini bese wengeza izixhumanisi kumashidi owadingayo usebenzisa umyalo Faka - Isixhumanisi (Faka - Isixhumanisi)

Ukushintsha okusheshayo phakathi kwamashidi

Ungasetha umbhalo oboniswe kuseli kanye nekheli leseli lapho ukuchofoza isixhumanisi kuzoholela khona.

Uma kunamashidi amaningi futhi ungafuni ukwenza inqwaba yezixhumanisi ngesandla, ungasebenzisa i-macro eyenziwe ngomumo ukuze wenze ithebula lokuqukethwe.

  • Ulenza kanjani ithebula lokuqukethwe lencwadi yokusebenzela ye-Excel ukuze uye eshidini olifunayo
  • Ukudala okuzenzakalelayo kwethebula lebhuku lokuqukethwe eshidini elihlukile elinezixhumanisi (isengezo se-PLEX)

shiya impendulo