Excel Format Painter: Kopi Kuumba Pakati Pematare

01 of 03

Excel uye Google Spreadsheets Format Painter

Kugadzira Mapepa Emashandisi Anoshandisa Format Painter

Iyo mifananidzo inoratidzika mune b b Excel neGoogle Spreadsheets inokubvumira kuti iwe nokukurumidza uye nyore nyore kukopa mafomu kubva kune imwe sero kana boka remasero kune imwe nzvimbo yepafashiti.

Mune mapurogiramu ose aya, chiitiko chacho chinonyanya kukosha paunowedzera kuumbwa mune pepa rekuita kune nzvimbo dzine data idzva panzvimbo yekuedza kugadzirisa mafomati akawanikwa pane data iripo,

MuExcel, maitiro ekukopa mapepa anosanganisira kukopa maitiro ekufambisa imwe kana dzimwe nguva kune imwe kana dzimwe nzvimbo dzakawanikwa:

• Pasi rimwechete pepaji
• Pasi pepa mapepa akasiyana-siyana mubhuku rimwechete rebhuku
• Mune mamwe mabhuku emabasa

02 of 03

Multiple Copying With Painter Format

.Copy Kugadziridza kune mamwe maSsetseti Epa Work in Excel

Aya matanho anotevera akashandiswa kushandiswa zvakasiyana-siyana zvekufambisa maitiro pane data iri muhomwe B mumufananidzo uri kumusoro kune data iri mumakamuri C uye D.

1. Wedzera zvose zvingasarudzwa zvaunoda kushandisa kumusiki wero (s).
2. Simbisai masero B4 kuB8 nemushonga we mouse.
3. Dzvanya paImba yebhu yebhoni .
4. Dzvanya pamufananidzo wemufananidzo wepirati (brashi yepende) kurutivi rworuboshwe rwebhoni-apo mutsara weguru uri kutarisana nepamusoro pebasa, bharuti rinoratidzika rinoratidzwa pamwe nehointer kuratidza kuti mufananidzo wemifananidzo wakashandurwa.
5. Simbisai masero C4 kuD8.
6. Izvo zvingasarudzwa zvekufambisa zvichakopwa kune nzvimbo itsva uye muvepeti wepadhi akadzimwa.

Kaviri Kushandura Format Painter ye Multiple Copying

Sezvambotaurwa pamusoro apa, imwe sarudzo inowanika muExcel chete inowedzera kaviri pane mufananidzo wemufananidzo wemufananidzo nemushonga we mouse.

Kuita izvi kunogadzirisa maitiro emutambi wemifananidzo akafuratirwa kunyange mushure mekunge uchitarisa pane imwe kana kupfuura mamwe masero.

Kushandisa izvi zvichita nyore kuti ikopike mafomiti kune dzimwe dzakawanda dzisingasviki (s) (s) dzinowanikwa pamashizha kana mamwe mabhuku ebasa.

Kukopa mafomatiro kune mamwe mapoka mashoma emasero muGoogle Spreadsheets, zvakakosha kudzokorora matanho ari kumusoro pamusoro pekukopa mafomiti kune imwe yechipiri pepaji yepasi.

Kuvhara Purogiramu Yakaitwa muExcel

Nzira mbiri dzekudzima mufananidzo wemifananidzo kana iri mukana yakawanda yekhopi mu Excel ndeyi:

1. Dhinda keseyi ESC pane keyboard.
2. Dzvidza kamwechete pane zvakarongwa nemufananidzo wemufananidzo paImba yebhu yebhoni.

Keyboard Shortcut ye Excel's Format Painter

A simple, two key shortcut does not exist for Excel's pepper image.

Zvisinei, izvi zvinotevera zvinoshandiswa zvinogona kushandiswa kutevedzera mufananidzo wemufananidzo. Idzi idzi dzinoshandisa shanduko mafomu maitiro muPaste Special dialog box .

1. Dhinda Ctrl + C - kuti ugofananidza zviri mukati memusero (s) -data uye kushandiswa kwekushandiswa-inzvimbo yesero (s) ichakomberedzwa nyerere dzinofamba.
2. Simbisai sero rekuenda kana masero ari pedyo.
3. Dhinda Ctr + Alt + V - kuti uzarure Paste Special dialog box.
4. Dhinda T + Pinda kuti unamate chete kuiswa kwemaitiro kunzvimbo yekuenda (s).

Sezvo mhashu dzinofamba dzinofanirwa kunge dzichishanda kumativi echitsauko (s), serofomu inogona kuderedzwa kazhinji nekudzokorora matanho 2 kusvika 4 pamusoro.

Gadzira Macro

Kana iwe ukashandisa mufananidzo wepeji nguva dzose, nzira iri nyore yekuishandisa nayo uchishandisa keyboard iyi ndiyo yekuumba macro uchishandisa maitiro akataurwa pamusoro apa uye apa shanduro yekutsinhanisa key iyo inogona kushandiswa kugadzirisa macro.

03 of 03

Google Spreadsheets Paint Format

Kopa Kufambisa kune imwechete kana kuti mamwe maScell ​​Adjacent kuGoogle Spreadsheets

Google Spreadsheets 'sarudzo yependeji yakasarudzwa, sekudanwa kwayo, haisi yakakwana seyoyo Excel pamwe chete, sezvo ichikwanisa kukopa mafomu ekugadzirisa kunzvimbo imwe chete panguva imwechete:

• Kuenda kune imwe nzvimbo yebasa rimwechete
• Kune mapepa akasiyana epafaira rimwe chete

Nzvimbo yeGoogle Spreadsheets 'haikwanise kukopa kuumba mafaira pakati pefaira.

Matanho anoshandiswa kutevedzera maitiro ekufambisa kubva kumasero B4: B8 kumakamuri C4: D8 inoratidzwa mumufananidzo uri pamusoro apa:

1. Wedzera zvose zvingasarudzwa zvekufambisa kune mamwe masero masero.
2. Simbisai masero B4 kuB8 nemushonga we mouse.
3. Dzvanya pikorodzano yepende yepende (mupepeti wepende) pachigadzirwa chebar.
4. Simbisai mairi masero aripo C4 kusvika kuD8.
5. Maikirwo ekufambisa kubva kumasero ari mu-column B achakopiwa kumasero ari mumakamuri C uye D uye chimiro chependemu chakadzimwa.

Multiple Kukopikisa nePaint Format

Sezvambotaurwa pamusoro apa, mapepa mafirimu inongopedzisira kuenzanisa kuumbwa kune imwe chete nzvimbo pane imwe nguva

Kukopa mafomatiro kune mamwe mapoka mashoma emasero muGoogle Spreadsheets, zvakakosha kudzokorora matanho ari kumusoro pamusoro pekukopa mafomiti kune imwe yechipiri pepaji yepasi.