Mukati
Microsoft Office Excel ine basa rinoisa mafomati akafanana ezvimedu zvetafura panguva imwe chete. Ichi chinyorwa chichatsanangura maitiro makuru echisarudzo.
Maitiro ekugonesa Format Painter
Iwe unogona kugonesa iyi modhi nenzira inotevera:
- Vhura Excel uye sarudza sero kubva kwaunoda kukopa fomati.
- Enda kuchikamu che "Kumba" kumusoro kwemenyu huru uye tinya bhatani re "Format Painter". Inowanikwa padivi peshoko rekuti "Insert".
- Sarudza huwandu hwemasero mutafura iyo yaunoda kuisa iyo yakafanana fomati seyekutanga element. Kana mushandisi aburitsa bhatani rekuruboshwe, oparesheni inopera.
Teerera! Mushure mekuita basa iri, icon yebroom ichaonekwa padivi peyakajairwa cursor muExcel.
Zvinoumba Format Painter
Kuti unzwisise zviri nani musoro wenyaya, zvinodikanwa kufunga akati wandei mikana iyo mafomati akadaro ane. Kune dzakawanda dzadzo:
- Kugona kukopa chimiro chesero rimwe. Nhamba yemasero kubva kwaunogona kukopa fomati haina kuganhurirwa.
- Basa rinoshanda kune ese ari maviri mitsara uye makoramu echero tafura. Uyezve, huwandu hwakasarudzwa hwezvinhu hunoenderana zvizere nehwekutanga.
- Nekubatsira kwechisarudzo ichi, zvinokwanisika kubvisa mafomu asina kufanira kubva kune mamwe masero etafura yetafura.
- Kana ukadzvanya bhatani refomati kaviri neLMB, murairo unogadziriswa, uye mushandisi achakwanisa kuunza maseru akawanda kufomati imwe chete kusvika adzvanya kiyi yeEsc kubva pakhibhodi.
- Kugona kwekugadzirisa zvinoenderana nemuenzaniso wechero zvinhu: mifananidzo, ruvara, machati, magirafu, nezvimwe.
Mahotkey ekuvhura Format Painter
MuExcel, chero murairo, basa rinogona kutangwa nemusanganiswa wemabhatani akakosha pakhibhodi yekombuta. Kugonesa iyo "Format Painter" modhi, iwe unozofanirwa kuita anotevera manipulations:
- Shandisa bhatani rekuruboshwe rembeva kusarudza huwandu hwemasero kana chinhu chimwe chine fomati yaunoda kukopa.
- Panguva imwe chete bata mabhatani e "Ctrl + C" kubva paPC keyboard, uchichinja kune dhizaini yeChirungu.
- Fambisa mbeva cursor kune imwe sero uye tinya "Ctrl + V" makiyi. Mushure meizvozvo, chinhu ichi chinotora chimiro chesero yekutanga pamwe nezviri mukati maro.
Zvinokosha! Iwe unogona zvakare kushandisa "Ctrl + Shift + V" musanganiswa kufomati zvinoenderana nemuenzaniso. Nekudaro, kuti uite izvi, uchafanirwa kunyora kadiki kodhi uye kuichengeta mubhuku rako remacro.
Mushure mekunge kodhi yanyorwa, hotkey inoda kuwedzerwa kune rondedzero yeExcel mirairo. Kuti uite basa racho, unofanirwa kuita akati wandei nhanho dziri nyore maererano neiyo algorithm:
- Pinda iyo "Tarisa" tebhu mubharu repamusoro rechirongwa.
- Wedzera iyo "Macros" menyu nekudzvanya LMB pamuseve uri padivi payo.
- Mune menyu yezvinyorwa, sarudza chinhu chine zita rimwechete.
- Muhwindo rinovhurwa, pasi pemutsara we "Macro Name", zita rekodhi yakambowedzerwa ichanyorwa. Inofanirwa kusarudzwa nebhatani rekuruboshwe uye tinya bhatani re "Parameters" mubhara rekushandisa riri kurudyi rwehwindo.
- Mutabhu inobuda, muchikamu che "Keyboard Shortcut", bata mabhatani e"Ctrl + Shift + V" kuti uwedzere kiyi inopisa, wobva wadzvanya pakanzi "Zvakanaka" kuisa shanduko.
Maitiro ekushandisa iyo "Ctrl+Shift+V" murairo
Mushure mekugadzira hotkey, unofanirwa kunzwisisa kuti ungashandise sei murairo uyu. Nheyo yekushanda kwemusanganiswa "Ctrl + Shift + V" inogona kuratidzwa seizvi:
- Sarudza huwandu hwezvinhu zvauri kuda kukopa fomati.
- Bata pasi "Ctrl + C" mabhatani kuti uwedzere zviri mukati mesero kune clipboard.
- Enda kune yaunoda pepa rebasa uye bata pasi musanganiswa "Ctrl + Shift + V".
- Tarisa mhinduro.
Mamwe Mashoko! Mushure mekudzvanya "Ctrl + C" makiyi, iyo yekutanga sero ichave yakasimbiswa mune inoenderana ruvara. Mamiriro ezvinhu aya anoratidza kutanga kwebasa rechikwata.
Iyo Format Painter basa inoita kuti zvive nyore kukopa akasiyana maumbirwo nemifananidzo. Kana iwe uchingoda kukopa zviri mukati meimwe sero, saka unogona kushandisa musanganiswa "Ctrl + Shift + V"
Maitiro ekukurumidza kukopa zviri mukati mesero mutafura
Kune nzira dzakawanda dzekukopa kwakadaro. Nekudaro, iyo yakapusa uye inoshanda nzira yakakamurwa kuita anotevera matanho:
- Sarudza chinhu chetafura array, izvo zviri mukati izvo zvinofanirwa kuendeswa kune imwe sero.
- Sarudza sero yaunoda nekuisarudza nebhatani rekuruboshwe.
- Fambisa chitubu chegonzo kumutsara wekupinda mafomula mumutsetse wepamusoro wemenu huru yechirongwa.
- Isa chikwangwani che "=" mumutsara uye unongedza kune kwakabva sero.
- Dzvanya "Enter" kubva pane keyboard kuti upedze kushanda.
- Tarisa mhinduro. Zviri mukati mechinhu chekutanga chinofanira kuenda kune chakasarudzwa.
Teerera! Saizvozvo, iwe unogona kuzadza mutsara unodiwa wemasero mundiro.
mhedziso
Saka, Microsoft Office Excel ine nhamba huru yezvinhu zvinobatsira izvo zvinokutendera kuti uite otomatiki imwe maitiro. Pateni pore fomati ndiyo imwe sarudzo yakadaro. Nzira dzese dzekuita nekuishandisa dzakurukurwa pamusoro apa.