Chengetedza ku Excel Using Shortcut Keys

Chengeta mangwanani, ponesa kazhinji!

Iwe wakaisa basa rakawanda muExpcel spreadsheet yako; usarega ichitsemuka nokuti wakakanganwa kuichengeta! Shandisa mazano aya kuti uchengetedze basa rako rakachengeteka uye rakachengetedzwa nguva inotevera iwe unoda iyo faira.

Excel Save Shortcut Keys

Mukuwedzera pakuchengetedza mafaira ebhuku rebhuku uchishandisa Puropu yekuchengetedza iri pasi peMenyu menu kana Chengetedza icon pane Quick Access toolbar, Excel ine sarudzo yekuchengetedza uchishandisa mashomanana ekutsvaira pa keyboard.

Iko kusanganiswa kweiyo nzira shoma ndeyokuti:

Ctrl + S

• Kana iyo faira yakachengetedzwa kare, iyo pointer ye mouse inoshanduka kusvika pane imwe girazi regirazi panguva yekuchengetedza.
• Kana bhuku rebhuku riri kuchengetwa kwekutanga, bhokisi re Save reSearch richazarura.

First Time Save

Apo faira inoponeswa kwekutanga, zvidimbu zviviri zvemashoko zvinofanira kuve zvataurwa mu Save As dialog box:

• Zita refaira (kusvika pamakumi maviri nema25 anosanganisira nzvimbo).
• Nzvimbo (folda) iyo faira ichachengetwa.

Save Frequently

Kubvira kushandiswa kweCtrl + S zvitsva zvitsvaga inzira yakadaro yekuchengeta data, iyo pfungwa yakanaka kuchengetedza kakawanda - zvishoma nemaminitsi mashanu - kuti urege kurasikirwa kwedata kana chiitiko chekombiyuta ichipera.

Pinning Save Mahara

Kubva Excel 2013, zvave zvichigoneka kuvhara nzvimbo dzinowanzochengetedzwa nzvimbo pasi pe Save As .

Kuita izvi kunogadzirisa nzvimbo yacho nyore nyore kusvika kumusoro kweAvaFold Folders list. Hapana mhedziso kune nhamba yezvimbo dzinogona kuvharwa.

Kuvhara nzvimbo yekuchengetedza:

1. Dzvanya paFaira> Chengetedza.
2. Muchengetedze seWhenwindo, shandisa mutsara weganda pane nzvimbo yaunoda pasi pePfolda Ichangopfuura.
3. Pasi kurudyi kwekona, chinyorwa chiduku chinopinza chepini chinomira chinowanikwa panzvimbo iyoyo.
4. Dzvanya pane pini yeiyo nzvimbo. Chifananidzo chinosvika kune chemufananidzo wakafanana wepini rinoratidza kuti nzvimbo yacho ikozvino yakanamatirwa kumusoro kweZviva Folders list.
5. Kuti usabvisa nzvimbo, chengetera pane zvakananga pini pikicha zvakare kuti uchinje zvakare kumutsara unopinza.

Kuchengetedza Excel Files muPom PDF Format

Chimwe chezvinhu zvakatanga kubudiswa muExcel 2010 chaiva kukwanisa kuchinja kana kuchengetedza maFelesheet eExpcel pdf format.

Ipa PDF file (Portable Document Format) inobvumira vamwe kuti vaone zvinyorwa vasina kuda chirongwa chepakutanga - seExcel - yakaiswa pamakombiyuta avo.

Pane kudaro, vashandisi vanogona kuzarura faira nehurongwa hwepachena hwekuverenga PDF seAdobe Acrobat Reader.

Faira yePFP inokubvumirawo kuti vamwe vaone dhesi repapaji rekusavapa mukana wekuchinja.

Kuchengetedza Pepa Rokushanda Rakashanda muPom PDF Format

Paunenge uchichengetedza faira muPdf format, nekusara chete ikozvino, kana kushanda kwepapaiti - iro ndiro pepaji riri pahwindo - rakachengetedzwa.

Matanho ekuchengetedza pepa reku Excel pamushumo wepa PDF uchishandisa Excel's Chengetedza sefaira rekutsvaga faira ndei:

1. Dzvanya paDhiyabhorosi tab yebhoni kuitira kuti uone zviripo zvemenyu.
2. Dzvanya pa Save Sezvo sarudzo yekuzarura Bhokisi reKurinda sebhokisi.
3. Sarudza nzvimbo yekuchengetedza faira pasi peKachengetedza Mutsara kumusoro kwebhokisi rebhokisi.
4. Tora zita refaira iri pasi peFiri zita remutsara pazasi kwebhokisi rebhokisi.
5. Dzvanya pamusana wemusara wepamusoro pakuguma kweChengetedza sepepeti yeropa pazasi kwebhokisi rebhokisi kuti uzarure mhando yekunyorera.
6. Bhura nepamusoro pekutsvaga kuti uwane uye tora pane PDF (* .pdf) sarudzo yekuita kuti ioneke muChengetedze sewepeji yemukana webhokisi rebhokisi.
7. Dzvanya Ponesa kuti uchengetedze faira mu PDF format uye uvhare bhokisi rebhokisi.

Chengetai Mapeji Akawanda kana Bhuku Rese Rebasa muPom PDF Format

Sezvakataurwa, zvisizvo Ponesa Sekusarudza chete inoponesa pepa rekushanda riripo mu PDF format.

Pane nzira mbiri dzekushandura kuchengetedza mapepa akawanda emabasa kana bhuku rose rebasa mu PDF format:

1. Kuti uchengetedze mapeji akawanda mubhuku rebhuku, ratidzai mabhesi emafambisi acho asati agonesa faira. Ndizvo chete mapepa aya achachengetedzwa mufaira yePFP.
2. Kuchengeta bhuku rose rebhuku:
   • Simbisai mapepa ose mapepa;
   • Sarudza Options muKachengeta Sebhokisi rebhokisi.

Cherechedza : Tsanangudzo yeChinobuda inongowanikwa mushure mekunge faira yefaira ishandurwa kuva PDF (* .pdf) mu Save As dialog box. Inokupa zvisarudzo zvakawanda pamusoro pehupi ruzivo uye deta zvakachengetwa pdf format.

1. Dzvanya pa PDF (* .pdf) sarudzo yekuita sarudzo yeChoice inowanikwa muChengetedza sepepeti yerudzi rwebhokisi rebhokisi;
2. Dzvanya pabhokisi kuti uzarure Options dialog box;
3. Sarudza Bhuku Rese Rokushandisa muShandisei chikamu chipi;
4. Dzvanya OK kuti udzoke kuIndaneti seBhokisi rebhokisi.