Ungayilungisa njani intloko yetafile kwi-Excel. Ukutshixa umgca ophezulu, i-cap enesidima

Xa usebenza neetafile ezinde ezingafakwanga kwisikrini ngokuthe nkqo kwaye unenani elikhulu leekholamu, isidingo sokukrola isikrini ukuze sivelise umgca ophezulu kunye nezihloko eziphezulu. Ukwenza lula kwinkqubo ye-Excel, kunokwenzeka ukulungisa i-cap yetafile ephezulu kwisikrini ngalo lonke ixesha de ifayile ivulekile. Apha ngezantsi kukho ukhetho lokufezekisa oku.

Kuyimfuneko ukukhusela umtya omnye kuphela.

Ukulandelelana kwezenzo ukukhusela umtya

1. Kwinqanaba eliphezulu lenkqubo, kufuneka uye kwithebhu "Jonga".
2. Kwicandelo "lefestile" (amagama esahlulo zidweliswe kumgca ongezantsi wetheyipu) ukufumana into ethi "qinisa le ndawo" kwaye ucofe unxantathu kwinxalenye yakhe elungileyo.
3. Kuluhlu oluvula, khetha "ukhusele intambo ephezulu" ngokucinezela iqhosha lemouse lasekhohlo. Isiphumo siya kuba lubukho obusisigxina kwitheyibhile yesikrini, sigciniwe kwaye emva kokuvala ifayile.

Ukulungisa i-caps kwimigca eliqela

Ukuba imigca emininzi iyadingeka, emva koko isenzo sahlukile:

1. Kwikholam esekhohlo yetafile, cofa kwiseli yomtya wokuqala engeyonxalenye ye-cap. Kule meko, le yiseli ye-a3.

2. Yiya kwi "Jonga" ithebhu, cofa kwi "lungisa le ndawo" kunye noluhlu lwesahlulo Khetha into ebonwayo ukuya ". Ngenxa yoko, yonke imigca ebekwe ngaphezulu kwelona liseseli ekhethiweyo lirekhodwa phezulu kwiscreen.

"Itafile e-Smart"-Enye inketho lokuqinisa umnqwazi

Lowo uqhelene neetafile ze-smart privel unokuthatha ithuba lendlela elungileyo yokudibanisa. Kuyinyani, olu khetho lusebenza kuphela kwimeko yomnqwazi womgca omnye.

Izenzo zokwenza "itafile enesilumko"

1. Kwi-ribbon tab "Ikhaya" libonisa yonke itafile.
2. Kwicandelo le "Stayles" (kwiphepha elingaphantsi leteyiphu), cofa kwi "fomothi njengeTheyibhile". Ifestile ivula ngeseti yezitayile zetafile. Kufuneka ucofe olona khetho lufanelekileyo.

3. Itheyibhile "yokufomatha" iwindows pops phezulu, apho imida yetafile yexesha elizayo ibonisiwe, kwaye itafile ye-Sheckbox "ineentloko" zikhona. Kuya kufuneka uqiniseke ukuba le yokugqibela iphawuli.
4. Vala ifestile ngokucinezela iqhosha "Kulungile".

Yenza itafile elumkileyo ngenye indlela:

1. Emva kokukhetha indawo oyifunayo, yiya kwi-ribbon tab kwaye ucofe kwi "Theyibhile".
2. Uluhlu lwe-pop-up, cofa kwi "Tewer" point.
3. Emva kokubonakala "kwetafile" i-window ivele nomxholo ofanayo kunye ne-fomating theindow "yokwenza izinto ezifanayo nezo sele zichazwe apha ngasentla. Ekugqibeleni, "itafile elumkileyo" iya kuvela nge-cap ezixhonywe phezulu.

Ungayiprinta njani itafile ngepakethi kwiphepha ngalinye

Xa uprinta itafile ehlala amaphepha aliqela, kubalulekile ukuba ube nesihloko sephepha ngalinye. Oku kukuvumela ukuba usebenze nayo nayiphi na iphepha eliprintiweyo ngokwahlukeneyo. Kwinkqubo ye-Excel, eli nqaku linikezelwe kwaye liphunyezwe ngolu hlobo lulandelayo.

1. Yiya kwitheyibhile ye-ribbon tab yokuphawula iphepha kunye nephepha "Useto lwephepha" (kumgca osezantsi we-rod) Cofa kwifestile ngotolo ukuya ngasekunene kombhalo.

2. Kwi "paramitha yephepha" iwindow evula, yiya "kwi-Sheet" ithebhu.
3. Cofa kwi "Window" yeWindows (yesibini ngasentla).
4. Buyela etafileni kwaye, ushukumise isikhombisi esithathe umbono wotolo omnyama obhekiswe ngasekunene, kumgca onamanani aphezulu, chaza umtya okanye umtya apho umtya wetafile.

5. Ngale nto zonke zezenzo zigqityiwe, nangona kunjalo, iziphumo zazo aziboniswanga kwiscreen.

Jonga iMbali yeWeksi yoxwebhu oluprintweyo - iphepha 1 nge-cap

Apha ngokucinezela oonxantathu kumgca ongezantsi wefestile okanye ukuskrola ivili le mouse, xa isikhombisi esifakwe kwiphepha letafile, unokujonga onke amaphepha ukukhangela iminqwazi nganye nganye.

Jonga kuqala i-Window ngaphambi kokushicilela uxwebhu - iphepha 2 ngesigqoko

Izigqibo

E-Excel, zimbini iindlela zokubonisa rhoqo kwiithebhu zetafile. Enye yazo ibandakanya ukusetyenziswa kwendawo eqingqiweyo yommandla, yesibini kukuguqula itafile kwi "Smart" usebenzisa ukufomatha kwendawo ekhethiweyo yokufakwa kuyo. Zombini iindlela zivunyelwe ukulungisa umgca omnye, kodwa okokuqala kuyayivumela ukuba yenze ngekesi equlathe imigca emininzi. I-Excel iluncedo olongezelelekileyo -Ukukwazi ukuprinta uxwebhu ngepaketi kwiphepha ngalinye, ethi, ewe, yonyusa ukusebenza kwawo.

Umyalezo Ungalungisa njani intloko yetafile kwi-Excel. Ukulungisa umgca ophezulu, umnqwazi onzima wabonakala kuqala kwitekhnoloji yolwazi.