Izindlela ezingu-3 zokushintsha ithebhu yephepha lokusebenzela I-Colors ku-Excel

Imibala yethebhu ingakusiza uhlale uhlelekile ngaphakathi kwespredishithi

Ukukusiza ukuthi uthole ulwazi oluthile kumafayili ama-spreadsheet amakhulu, kuvame ukusiza ikhodi yombala amathebhu wephepha lamaphepha okusebenzela aqukethe idatha ehlobene. Ngokufanayo, ungasebenzisa amathebhu ahlukene ahlukene ukuze uhlukanise phakathi kwamashidi aqukethe ulwazi olungathintana.

Enye indlela ukudala uhlelo lwemibala yamathebhu enikeza izinkomba zokubuka okusheshayo ngokuya esiteji sokuphelela kwamaphrojekthi - njengokuhlaza okuqhubekayo nokubomvu okuphelile.

Lezi yizinketho ezintathu zokushintsha umbala wethebhu wephepha leshidi lokusebenzela elilodwa kubhuku lokusebenzela:

• Ukusebenzisa ukhiye wekhibhodi.
• Ukuchofoza ngakwesokudla kuthebhu leshidi (mhlawumbe indlela elula).
• Ukusebenzisa inketho yamathebhu efomathi.

Shintsha ithebhu yephepha lokusebenzela I-Colors Sebenzisa Amakhidibhodi wekhibhodi noma iMouse

Inketho 1 - Ukusebenzisa ama-Keys Key Key:

Qaphela : Ukhiye we-Alt ekulandelaneni ngezansi akudingeki ukugcinwa phansi ngenkathi ezinye izinkinobho zicindezelwa, njengezinye izinqamuleli zekhibhodi. Isihluthulelo ngasinye sicindezelwe futhi sikhululwe ngokulandelana.

Lokho kusetjenziswa kwamacrosoft kusenza kusebenze imiyalo ye-ribbon. Uma ukhiye wokugcina ngokulandelana - i-T - icindezelwe futhi ikhishwe, i-palette yombala yokushintsha umbala wethebhu leshidi ivuliwe.

1. Chofoza kuthebhu yokusebenzela ukuze wenze ishidi elisebenzayo - noma sebenzisa izinqamuleli zekhibhodi ezilandelayo ukukhetha ishidi elifunayo:

Ctrl + PgDn - thuthela eshidi ngakwesokudla Ctrl + PgUp - thuthela eshidi ngakwesokunxele

2. Cindezela bese ukhulula ngokulandelana ngenhlanganisela eyinhloko elandelayo ukuze uvule i-palette yombala esekelwe ngaphansi kokukhethwa kwefomathi kuthebhu lasekhaya lebhande :

I-Alt + H + O + T

3. Ngokuzenzakalelayo, isikhala sombala sombala wethebhu wamanje sigcizelelwe (sizungezwe umngcele we-orange). Uma umbala wethebhu ungakashintshwa ngaphambilini lokhu kuzoba mhlophe. Chofoza nge-pointer yegundane noma sebenzisa izinkinobho zemicibisholo ekhibhodi ukuhambisa okugqamile kumbala oyifunayo ku-palette;

4. Uma usebenzisa imicibisholo yomcibisholo, cindezela ukhiye wokungena kwikhibhodi ukuqedela ukushintsha kombala;

5. Ukubona imibala engaphezulu, cindezela ikhi le- M ekhibhodi ukuvula iphalethi yombala ongokwezifiso.

Inketho yesibili - Chofoza ngakwesokudla ithebhu yephepha:

1. Chofoza ngakwesokudla kuthebhu yephepha lokusebenzela ofuna ukuphinde umbala ukuze wenze ishidi elisebenzayo futhi uvule imenyu yokuqukethwe;

2. Khetha Umbala weThabhu ohlwini lwamenyu ukuvula iphalethi yombala;

3. Chofoza umbala ukuze ukhethe;

4. Ukuze ubone imibala engaphezulu, chofoza ku- Colour More ngaphansi kwephalethi yombala ukuvula iphalethi yombala ongokwezifiso.

Indlela 3 - Finyelela Option Ribbon nge Mouse:

1. Chofoza kuthebhu yephepha lokusebenzela elizobizwa kabusha ukuze lenze ishidi elisebenzayo;

2. Chofoza ithebhu yasekhaya yebhande;

3. Chofoza inketho yefomathi ebhanini ukuze uvule imenyu ehlayo;

4. Esikhathini sokuhlela Amashidi amaSpredishithi emenyu, chofoza umbala weThabhu ukuvula iphalethi yombala;

5. Chofoza umbala ukuze ukhethe;

6. Ukuze ubone imibala engaphezulu, chofoza ku- Colour More ngaphansi kwephalethi yombala ukuze uvule umdwebo wombala wendabuko.

Ukushintsha Umbala weThabhu Wama-Worksheets amaningi

Ukushintsha umbala wethebhu wamashidi wamashidi amaningi omsebenzi kudinga lawo ma-sheet onke akhethwe ngaphambi kokusebenzisa enye yezindlela ezichazwe ngenhla.

Amashidi akhethiwe angadonsela phambili - eduze komunye nomunye, njengamashidi eyodwa, amabili, amathathu - noma amashidi ngamanye angakhethwa, njengamashidi amane nesithupha.

Wonke amathebhu womsebenzi akhethiwe azoba umbala ofanayo.

Ukukhetha ama-worksheets ahambisanayo

1. Chofoza kuthebhu kwiphepha lokusebenzela elisekugcineni kwesokunxele kweqembu ukuze lishintshwe ukuze lenze ishidi elisebenzayo.

2. Bamba phansi ikhi Shift ekhibhodi.

3. Chofoza kuthebhu yeshidi ekugcineni kwesigcawu - wonke amashidi okusebenza phakathi kwamaqalo okuqala nokuphela kufanele akhethwe.

4. Uma amashidi amaningi kakhulu akhethwe ngephutha, chofoza ekhasini lokugcina elifanele - nekhiye le- Shift lisacindezelwe - ukukhetha amashidi okusebenza angafuneki.

5. Sebenzisa enye yezindlela ezichazwe ngenhla ukuze ushintshe umbala wethebhu kuwo onke amashidi akhethiwe.

Ukukhetha ama-worksheets ngabanye

1. Chofoza kuthebhu yephepha lokusebenzela lokuqala ukwenza ishidi elisebenzayo;

2. Gcina ikhi ye- Ctrl ekhibhodi bese uchofoza amathebhu azo zonke ama-worksheets okuzoguqulwa - akudingeki ukuba akhe iqembu elixubile - njengoba kuboniswe ngamashidi amane nesithupha emfanekisweni ngenhla;

3. Uma ishidi likhethwe ngephutha, chofoza kukho okwesibili - ukhiye we-Ctrl usacindezelwe - ukuwukhetha;

4. Sebenzisa enye yezindlela ezichazwe ngenhla ukuze ushintshe umbala wethebhu kuwo onke amashidi akhethiwe.

Imithetho Yemibala Yethebhu

Uma imibala yombhalo yamashidi ishintshiwe, imithetho i-Excel elandela ekuboniseni imibala yamathebhu yilezi:

1. Ukushintsha umbala wethebhu wephepha lokusebenzela elilodwa:
   • Igama lephepha lokusebenzela likhonjiswe kumbala okhethiwe.
2. Ukushintsha umbala wethebhu wephepha lokusebenzela elingaphezu kwelilodwa:
   • Amathebhu wephepha lokusebenza asebenzayo agcizelelwe kumbala okhethiwe.
   • Wonke amanye amathebhu womsebenzi abonisa umbala okhethiwe.