Mukati
Mune ino 2-chikamu chinyorwa, Terry anotaura nezve chinangwa chezvitaera muMicrosoft Excel. Muchikamu chekutanga, iwe unozodzidza maitiro ekufometa maseru zvine hungwaru, uye muchikamu chechipiri, iwe uchadzidza mamwe emhando yepamusoro mafomati sarudzo.
Zvitaera muMicrosoft Excel pasina mubvunzo ndechimwe chezvinonyanya kufuratirwa, zvisingashandiswe, uye zvisingatarisirwe maficha eExcel.
Zvisinei nekuwedzera kwenzvimbo paRibhoni yeMicrosoft Excel 2007 yakatsaurirwa kune ichi chimiro, vashandisi vazhinji (ini ndakasanganisirwa) ndinoita chikanganiso chekugadzirisa mafomati maseru pabepa rebasa, pane kushandisa maminetsi mashoma enguva yavo yakakosha vachigadzira zvitaera zvetsika izvo zvinozoita. inogona kushandiswa nekungodzvanya mbeva mbiri.
Unoziva meseji yemhosho iyi:Mafomati emasero akawanda akawanda.“? Kana hongu, saka iwe unozoona zvichibatsira kushandisa zvitaera muMicrosoft Excel.
Nehungwaru yakashandiswa Excel Styles ichakuchengetera nguva mukufamba kwenguva! Tisingatauri nezvekuyamura kwakakosha mukugadzirisa masero, kutaridzika kweyunifomu yematafura uye kureruka kwekuona kwavo. Uye zvakadaro, kunyangwe pakati pevashandisi vane ruzivo rweExcel, chishandiso ichi hachisati chafarirwa.
Ichi chinyorwa hachina kuitirwa kupindura mubvunzo kuti sei isu tisingashandisi masitayipi muMicrosoft Excel. Chaizvoizvo, pamwe nenhaurirano dzekusimbisa Microsoft Excel mabhuku ebasa nekubatanidza masitaera nematurusi ekusimbisa data.
Muchikamu chino, tichatarisa kushanda nemaitiro, apo ini ndinokupa nhanho-nhanho murairo wekushanda nechombo ichi, uye ipapo, muchikamu chechipiri chechidzidzo, tichadzidza maitiro akasiyana-siyana uye marongero. . Ini ndinokuratidza maitiro ekugadzirisa masitayera, kugovera mamwe mazano ekushandisa Microsoft Excel masitayipi mubasa rako rezuva nezuva, uye iwe uchagara uchiwana mamwe anobatsira matipi akashinga muzvinyorwa zvangu.
Chekupedzisira, zvinofanirwa kutaurwa kuti, sezvazvakaita kune akawanda maturusi eMicrosoft, masitaera aripo mune ese maapplication eMicrosoft Office suite. Pano tichatarisa pane zvitaera muMicrosoft Excel, asi izvo zvekutanga uye matekiniki anotsanangurwa anozoshanda kune chero Microsoft Office application.
Saka ndezvipi zvitaera muMicrosoft Excel?
Zvitaera muMicrosoft Excel chishandiso chinowanikwa pasi petabhu Home (Kumba). Zvinokutendera kuti uise sarudzo dzakafanogadzirirwa kufomati sero kana boka remaseru nekungodzvanya kakati.
Iko kune muunganidzwa we preset masitaera atomisikidzwa uye akagadzirira kushandisa. Iwe unogona kuzviwana nekungodzvanya pane iyo icon. Styles (Zvitaera) sezvaratidzwa pamufananidzo uri pamusoro.
Iwe uchaunzwa nezvakawanda sarudzo (ona mufananidzo uri pazasi). Kutaura zvazviri, kubatsira kwavo hakuna mubvunzo. Asi usazvinetse, zvinokwanisika kuchinjisa masitaera ekutanga kuti aenderane nezvido zvako, kana, zvakatonyanya kunakidza, gadzira yako wega-ye-a-mhando maitiro! Isu tichagara pane izvi zvakadzama muchikamu chechipiri chechinyorwa.
Kushandisa masitaera muExcel kunokupa chivimbo chekuti fomati iri pasi pekutonga kwako. Kushandisa masitayera kunosevha nguva yaunopedza uchigadzira nemaoko maseru etafura uye kunokupa humwe hudzamu hwechiitiko, kunyanya kana uchishandira pamwe (tichataura zvakawanda nezve mushandisi ruzivo gare gare).
Chii chaunoda kuziva kushandisa zvitaera muMicrosoft Excel?
Iwe uchafara kunzwa kuti hapana mhedziso zvinodikanwa zvekushandisa masitaera muMicrosoft Excel.
Ehe, zvinobatsira kujairana nefomati dialog uye ega ega maitiro, kunyanya kana iwe ukaronga kugadzira yako maitiro, asi izvi hazvisi izvo zvinodiwa. Muchokwadi, chishandiso ichi chiri nyore kushanda nacho, kunyangwe kune avo vakatanga Excel kekutanga!
Iwo aripo masitaera ekufomatisa sarudzo ane matanhatu maseru hunhu, ayo anowirirana nematabo matanhatu mubhokisi renhaurirano. Fomati Masero (cell format).
Tinogona kushandisa chero nhamba yefomati yezvinhu inowanikwa kune yega yega hunhu, chinonyanya kukosha ndechekukwana mukati memiganho inotsanangurwa neMicrosoft Excel, iyo inenge 4000 akasiyana masero mafomati mubhuku rimwe rebasa (kudzivisa yambotaurwa yeExcel yekukanganisa meseji).
Chiziviso cheMushanduri: YeExcel 2003 uye yapfuura (.xls extension), huwandu hwehuwandu hwemafomati anogona kuchengetwa mufaira ndeye 4000 akasiyana misanganiswa. MuExcel 2007 uye gare gare (extension .xlsx), nhamba iyi yakawedzera kusvika 64000 mafomati.
Izvo zvakakosha kuyeuka kuti, senge macro, chero nyowani yeMicrosoft fomati chimiro chakanangana nebhuku. Izvi zvinoreva kuti zvakachengetwa mune rimwe bhuku rekushanda uye zvinongowanikwa mubhuku rebasa iroro kusvikira wapinza manyorerwo acho mune rimwe bhuku rebasa. Tichaona kuti izvi zvinoitwa sei muchikamu chechipiri chechinyorwa.
Nzira yekushandisa sei preset style?
Kuisa chimiro chakafanorongwa kuExcel masero:
- Sarudza masero ayo maitiro anofanira kushandiswa.
- Vhura paMicrosoft Excel Ribbon: Home (Kumba) > Styles (Maitiro) > Zvitaera zvemasero (cell styles)
Zano rinobatsira! Ndokumbira utarise kuti pakusarudza masitayera, inopindirana preview inoshanda - izvi zvinoreva kuti kana iwe uchitenderera pamusoro pemhando dzakasiyana-siyana sarudzo, masero akasarudzwa anoshanduka. Pfungwa yakanaka, Microsoft!
- Sarudza chero maitiro emaseru nekudzvanya pairi negonzo.
Ndizvo! Masero ese akasarudzwa achagadziriswa zvinoenderana nemaitiro akasarudzwa!
Zano rinobatsira! Kana uchinge watsanangura maitiro emaseru, kushandura chero yemhando yefomati panguva imwe chete ichave chikamu chechina cheminiti basa kwauri, yakaderedzwa kushandura masitayera paramita, pachinzvimbo chekuti ingangoita maawa anoshandiswa iterating uye nemaoko kushandura mafomati. mutafura!
Kune ani nani anofarira kudzidza zvakawanda nezve emhando yepamusoro sarudzo muMicrosoft Excel, tarisa chikamu chechipiri chechinyorwa changu.