Mafupomu Achidule

Njira Zowonjezera Zowonjezera Zokambirana Zowoneka ku Zida Zambiri ndi Zida

Phunzirani zonse za makina osintha, kuphatikizapo kuphatikiza kugwiritsa ntchito Excel ku mphamvu yake yonse.

01 pa 27

Ikani New Worksheet mu Excel

Ikani New Worksheet mu Excel. © Ted French

Tsamba la Excel likuwonetsani momwe mungayikiritsire pepala latsopano mu bukhu la ntchito pogwiritsa ntchito njira yomasulira. Lembani Tsamba Latsopano la Excel pogwiritsa ntchito Keyboard Shortcut Press ndipo gwiritsani chinsinsi SHIFT pa keyboard. Dinani ndi kumasula f11 F key pa makiyi. Pepala latsopano lamasewera lidzalowetsedwa mu bukhu la ntchito yamakono. Kuwonjezera zowonjezera mapepala akupitiriza kufalitsa ndi kumasula filo F11 pamene akugwiritsira ntchito key SHIFT. Zambiri "

02 pa 27

Lembani Malemba awiri pa Excel

Lembani Malemba awiri pa Excel. © Ted French

Lembani mameseji mu selo Ngati mukufuna kuti mauthenga awoneke pa mizere yambiri mu selo, mukhoza kupanga selo kuti mawuwo alowe modzidzimutsa, kapena mungathe kulowetsa mzere wotsatira. Kodi mukufuna kutani? Lembani malemba pokhapokha Mulowetsani mzere Wembani mwatsatanetsatane Pomwe mukulemba, sankhani maselo omwe mukufuna kupanga. Kabukhu Kakang'ono, mu Gulu Logwirizanitsa, dinani Chojambula Chojambula Chithunzi. Zithunzi Zamakono Zamakono Zowonongeka Zomwe zili mu selo wraps kuti zigwirizane ndi chigawochi. Mukasintha chigawo cha m'mbali, kutsekera deta kumasintha. Ngati malembo onse atakulungidwa sakuwonekeratu, mwina chifukwa chakuti mzerewu waikidwa pamtunda wapadera kapena kuti mawuwo ali mumaselo osiyanasiyana omwe agwirizanitsidwa. Kuti malemba onse atakulungidwa awonetseke, chitani zotsatirazi kuti musinthe kutalika kwa mzere: Sankhani selo kapena mtundu umene mukufuna kusintha kutalika kwa mzere. Pabukhu la Pakumba, m'gulu la Maselo, dinani Pangani. Chithunzi Chamakono Chachidutswa Pansi pa Sekondi, chitani chimodzi mwa zotsatirazi: Kuti muthe kusintha msinkhu wa msinkhu, dinani Kudzala Mtengo Wokwera. Kuti muwone kutalika kwa mzere, dinani Mzere Wolemera, ndiyeno yesani kutalika kwa mzere umene mukufuna mu Row height box. Chiphuphu Mungathe kukokanso malire apansi a mzere kupita kumtunda womwe umasonyeza malemba onse atakulungidwa. Pamwamba pa Tsamba Pamwamba pa tsamba Lowani mzere wosweka Mutha kuyambitsa mzere watsopano palemba iliyonse pa selo. Dinani kawiri selo limene mukufuna kulowa mzere. Kusintha kwa makiyibodi Mungasankhire selo, ndiyeno yesani F2. Mu selo, dinani malo omwe mukufuna kupumula mzere, ndipo pezani ALT + ENTER.

Mndandanda wa malemba a Excel ndi maonekedwe okonzedwa bwino omwe amakulolani kuti muyang'ane mawonekedwe a ma labelle ndikukwera patsamba lanu.

Malembo olembera amakulolani kuti muike malemba pamzere wambiri mu selo imodzi osati kukhala ndi mauthenga omwe akufalitsidwa pamaselo angapo pa tsamba .

Mawu akuti "luso" la chigawo ichi ndikulumikiza malemba ndipo gulu lothandizira kulemberana malemba ndi:

Alt + Lowani

Chitsanzo: Kugwiritsa Ntchito Zowonjezera Zowonjezera Kulemba Malemba

Chitsanzo pogwiritsa ntchito mndandanda wa malemba a Excel:

  1. Mu selo D1 lembani mawuwa: Malipiro a Mwezi uliwonse ndi kukanikiza fungulo lolowamo ku Enter .
  2. Popeza malembawo ndi otalika kwambiri kwa selo, ayenera kutaya mu selo E1.
  3. Mu selo E1 lembani mawuwa: Zowonongeka mwezi ndi mwezi ndikusindikizira fungulo lolowamo pa makiyi.
  4. Mwa kulowetsa deta mu E1 chizindikiro chake mu selo D1 chiyenera kudulidwa kumapeto kwa selo D1. Komanso, malemba mu E1 ayenera kutaya mu selo kupita kumanja.
  5. Kuti athetse mavutowa ndi malemba awa, yikani maselo D1 ndi E1 mu tsamba la ntchito.
  6. Dinani pa tsamba la Pakiti.
  7. Dinani pa batani lolemba Wembali pa kaboni .
  8. Malembo m'maselo D1 ndi E1 ayenera tsopano kuwonetseredwa bwino ndi malemba osweka mu mizere iwiri popanda kutsanulira m'maselo apafupi.

Mndandanda wa malemba a Excel ndi maonekedwe okonzedwa bwino omwe amakulolani kuti muyang'ane mawonekedwe a ma labelle ndikukwera patsamba lanu. M'malo mowonjezera mazenera a mapepala kuti apange mutu wautali powonekera, kulembera mawu kumakupatsani inu malemba pa mizere yambiri mu selo limodzi. Zolembera Malemba a Excel Chitsanzo Kwa chithandizo ndi chitsanzo ichi, onani chithunzi pamwambapa. Mu selo G1 lembani mawuwa: Malipiro a mwezi uliwonse ndi kukanikiza ENTER kwachinsinsi pa kambokosi. Popeza Malipiro a Mwezi ndiatali kwambiri kwa selo yake, idzataya mu selo H1. Mu selo H1 lembani mawuwa: Zowonongeka mwezi ndi mwezi ndikusindikizira ENTER kwachinsinsi pa kambokosi. Deta ikadalowa mu selo H1 yoyamba yolemba Monthly Income iyenera kuchotsedwa. Kuti mukonze vutoli, jambulani maselo G1 ndi H1 pa spreadsheet kuti muwawonetse iwo. Dinani pa tsamba la Pakiti. Dinani pa batani lolemba Wembali pa kaboni. Malembo m'maselo G1 ndi H1 ayenera tsopano kuwonetseredwa bwino ndi malemba osweka mu mizere iwiri popanda kutsanulira m'maselo apafupi.

Phunziroli likuphatikiza momwe mungagwiritsire ntchito mzere wambiri mu selo limodzi lamasamba.

Mawu akuti "luso" la chigawo ichi ndikulumikiza malemba ndipo gulu lothandizira kulemberana malemba ndi:

Alt + Lowani

Chitsanzo: Kugwiritsa Ntchito Zowonjezera Zowonjezera Kulemba Malemba

Kuti mugwiritse ntchito mawonekedwe a malemba a Excel pogwiritsa ntchito khibodiyo:

  1. Dinani mu selo kumene mukufuna kuti lembalo likhale
  2. Lembani mzere woyamba wa malemba
  3. Lembani ndi kugwiritsira chingwe cha Alt pa makiyi
  4. Sakanizani ndi kumasula makiyi a Kulowa pa khibhodi popanda kumasula makiyi a Alt
  5. Tulutsani makiyi a Alt
  6. Mfundo yolembera iyenera kusunthira kumzere uli pansipa
  7. Lembani mzere wachiwiri wa malemba
  8. Ngati mukufuna kulowa mizere iwiri yolemba, pitirizani kukanikiza Alt + Lowani pamapeto pa mzere uliwonse
  9. Pamene malemba onse alowetsedwa, dinani makiyi a Enter mu makinawo kapena dinani ndi mbewa kuti musamuke ku selo lina
Zambiri "

03 a 27

Onjezerani Tsiku Lino

Onjezerani Tsiku Lino. © Ted French

Phunziroli likuphatikiza momwe mungayonjezere mwatsatanetsatane tsiku lomwe likugwiritsidwa ntchito pogwiritsa ntchito kamphindi.

Kuphatikizira kwakukulu kwa kuwonjezera tsikuli ndi:

Ctrl + ; (key-colon key)

Chitsanzo: Kugwiritsa Ntchito Njira Zowonjezera Kuti Muwonjezere Tsiku Lino

Kuwonjezera tsiku lamakono ku tsamba lolemba pogwiritsa ntchito kamphindi:

  1. Dinani pa selo komwe mukufuna tsikulo.
  2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
  3. Dinani ndi kumasula fungulo lachimake ( ; ) pa kibokosi popanda kumasula makiyi a Ctrl.
  4. Tulutsani makiyi a Ctrl.
  5. Tsiku lamakono liyenera kuwonjezeredwa pa tsamba la ntchito mu selo losankhidwa.

Zindikirani: Kusintha kwachibokosiku sikugwiritsa ntchito ntchito YOLODA kotero kuti tsikulo silikusintha nthawi iliyonse pamene tsamba lamasamba likutsegulidwa kapena kubwezeretsedwa. Zambiri "

04 pa 27

Chidule Chachidule mu Excel Pogwiritsa Ntchito Zowonjezera Makatani

Chidule Chachidule mu Excel Pogwiritsa Ntchito Zowonjezera Makatani. © Ted French

Chidule Chachidule mu Excel Pogwiritsa Ntchito Zowonjezera Makatani

Mfundoyi ikukhudza momwe mungalowe mwamsanga ntchito ya Excel ya SUM kuti muwonjezere deta pogwiritsa ntchito makina osatsekera pa makiyi.

Kuphatikiza kwachinsinsi kulowa ntchito SUM ndi:

" Alt " + " = "

Chitsanzo: Kulowa Ntchito ya SUM pogwiritsa ntchito njira zadule

  1. Lowetsani deta zotsatirazi mu maselo D1 mpaka D3 a tsamba la Excel: 5, 6, 7
  2. Ngati ndi kotheka, dinani pa selo D4 kuti mupange selo yogwira ntchito
  3. Lembani ndi kugwiritsira chingwe cha Alt pa makiyi
  4. Dinani ndi kumasula chizindikiro chofanana ( = ) pa kibokosi popanda kumasula makiyi a Alt
  5. Tulutsani makiyi a Alt
  6. Ntchito ya SUM iyenera kulowa mu selo D4 ndi ma D1: D3 omwe amatsindikitsidwa ngati kutsutsana kwa ntchito
  7. Lembani fungulo lolowamo lolowamo mu khibhodi kuti mukwaniritse ntchitoyo
  8. Yankho 18 liyenera kuoneka mu selo D4
  9. Mukasindikiza pa selo D4 ntchito yonse = SUM (D1: D3) imawoneka mu barra ya fomu pamwamba pa tsamba.

Njira yachiduleyi ingagwiritsidwe ntchito pazomwe mukuwerengera mizere komanso mizere.

Dziwani : SUM yapangidwa kuti ikhale pansi pa deta ya deta kapena kumapeto kwa deta.

Ngati ntchito ya SUM imalowa pamalo osakhala awiriwa, maselo ambiri osankhidwa ngati ndondomeko ya ntchito sangakhale olakwika.

Kuti musinthe mawonekedwe osankhidwa, gwiritsani ntchito ndondomeko ya mouse kuti muwonetsere maulendo oyenera musanatsegule fungulo lolowamo kuti mukwaniritse ntchito . »

05 a 27

Kuwonjezera Nthawi Yamakono

Kuwonjezera Nthawi Yamakono. © Ted French

Phunziroli likufotokoza mmene mungapangire mwamsanga nthawi yeniyeni ku tsambalo pogwiritsira ntchito kambokosi kokha:

Kuphatikizira kwawowonjezera nthawi ndi:

Ctrl + Shift + : (key key)

Chitsanzo: Kugwiritsa Ntchito Zowonjezera Zowonjezera Kuwonjezera Nthawi Yamakono

Kuwonjezera nthawi yeniyeni ku tsambali pogwiritsa ntchito khibodiyi:

  1. Dinani mu selo kumene mukufuna nthawi yoti mupite.

  2. Dinani ndi kugwirizira makina a Ctrl ndi Shift pa makiyi.

  3. Dinani ndi kumasula makiyi a colon (:) pa kibokosi popanda kumasula makiyi a Ctrl ndi Shift .

  4. Nthawi yamakono idzawonjezedwa ku spreadsheet.

Zindikirani: Kusintha kwachibokosiku sikugwiritsire ntchito ntchito YOTSIRIZA kotero kuti tsiku silikusintha nthawi iliyonse tsamba lamasamba likutsegulidwa kapena kusinthidwa.

Zojambula Zina Zopangira Zopangira

Zambiri "

06 pa 27

Yesani Hyperlink

Yesani Hyperlink. © Ted French

Ikani Hyperlink mu Excel Pogwiritsa Ntchito Zowonjezera Makatani

Mauthenga ogwirizana : Yesani ma Hyperlink ndi Bookmarks ku Excel

Nthano iyi ya Excel ikuphimba momwe mungayikirane mwatsatanetsatane wothandizira malemba omwe mwasankha pogwiritsa ntchito makina osatsekera mu Excel.

Mgwirizano wambiri womwe ungagwiritsidwe ntchito kukhazikitsa chithunzithunzi ndi:

Ctrl + k

Chitsanzo: Yesani Hyperlink pogwiritsa ntchito njira zadule

Pothandizidwa ndi malangizo awa dinani pa chithunzi pamwambapa

  1. Mu pepala la Excel pakani pindani pa selo A1 kuti likhale selo yogwira ntchito
  2. Lembani mawu kuti agwiritse ntchito ngati malemba a anchor monga Spreadsheets ndi kulumikiza fungulo lolowani pa makiyi
  3. Dinani pa selo A1 kuti mupangenso selo yogwira ntchito
  4. Dinani ndi kusunga makiyi a Ctrl pa makiyi
  5. Koperani ndi kumasula kakalata k ( k ) makiyi pa makiyi kuti mutsegule bokosi la dialog Insert
  6. Mu Adilesi: mzere pansi pa bokosi la bokosi la URL yonse monga:
    http://spreadsheets.about.com
  7. Dinani Ok kuti mutsirize ma hyperlink ndi kutseka bokosi la dialog
  8. Malemba a ancholo mu selo A1 ayenera tsopano kukhala a buluu mu mtundu ndi ndondomeko yosonyeza kuti ili ndi hyperlink

Kuyesa Hyperlink

  1. Ikani pointer la mouse pa hyperlink mu selo A1
  2. Mtsuko wamatsuko umasintha ku chizindikiro cha dzanja
  3. Dinani pamutu wotsitsika wa anchor
  4. Wosakatuli wanu ayenera kutsegulira ku tsamba lodziwika ndi URL

Chotsani Hyperlink

  1. Ikani pointer la mouse pa hyperlink mu selo A1
  2. Mtsuko wamatsuko umasintha ku chizindikiro cha dzanja
  3. Dinani pakanema malemba a anchor kuti mutsegule Chotsitsa Chotsitsa
  4. Dinani Chotsani Hyperlink kusankha mndandanda
  5. Mtundu wabuluu ndi mzere wozunzikirapo ayenera kuchotsedwa palemba lachikale chomwe chikusonyeza kuti hyperlink yachotsedwa

Zowonjezera Zowonjezera Zida

  • Ikani Kukonzekera kwa Ndalama
  • Kugwiritsa ntchito Zowoneka Zokonzedwa
  • Onjezani malire mu Excel
  • Zambiri "

    07 pa 27

    Onetsani Maonekedwe

    Onetsani Maonekedwe. © Ted French
    Mgwirizano wambiri womwe ungagwiritsidwe ntchito powonetsera maonekedwe ndi: Ctrl + `(makina oyimitsa mawu) Pa makibodi ambiri, makiyi amodzi a mchere ali pafupi ndi fungulo 1 nambala kumbali yakumanzere ya makina ndi kumawoneka ngati kumbuyo apostrophe. Onetsani mafomu pogwiritsira ntchito njira zochepetsera chitsanzo Chonde dinani makina a Ctrl pa makiiibulo Tsindirani ndi kumasula makiyi (`) ofunikira pa kibokosi popanda kumasula makiyi a Ctrl Tulutsani makiyi a Ctrl Onetsani maonekedwe Onetsani maonekedwe asasinthe spreadsheet, njira yokha yomwe imawonetsedwa. Zimapangitsa kuti mupeze mosavuta maselo okhala ndi mawonekedwe Akukuthandizani kuti muwerenge mwachangu machitidwe onse kuti muwone zolakwika Mukamalemba pa fomu, Excel ikuwonetsera mtundu wa mafotokozedwe a maselo omwe amagwiritsidwa ntchito mu njirayi. Izi zimakuthandizani kudziwa momwe deta ikugwiritsidwira ntchito mu njira. Sindizani mapepala ali ndi mawonekedwe awonetsedwe atsegulidwa. Kuchita zimenezo, kukulolani kuti mufufuze spreadsheet kuti mupeze zovuta. Zambiri "

    08 pa 27

    Zowonjezera Zowonjezera Zake - Sintha

    Phunziro lachidule lachidule la Excel likuwonetsani momwe mungasinthire kusintha kosinthidwa pa tsamba la Excel.

    Maphunziro ofanana: Chidule cha Kutulutsa kwa Excel .

    Zindikirani: Ndikoyenera kukumbukira kuti mukamagwiritsa ntchito Pewani, "imasiyanitsa" zochita zanu pazomwe mukuzigwiritsa ntchito.

    Mgwirizanowu wachinsinsi wafupikitsidwe ntchito "kusintha" kusintha ndi:

    Chitsanzo cha Mmene Mungasinthire Kusintha pogwiritsa Ntchito Makhalidwe Odule

    1. Lembani deta yanu mu selo , monga A1 mu spreadsheet ndikusindikizira Enter key pa makiyi.

    2. Dinani pa selo kuti mupange selo yogwira ntchito .

    3. Dinani pa tsamba la Home laboni .

    4. Gwiritsani ntchito njira zotsatirazi zomwe mungapange pa deta yanu:
      • sintha mtundu wa maonekedwe,
      • wonjezerani chigawocho,
      • onetsetsani,
      • sintha mtundu wazithunzi kwa Arial Black,
      • limbani deta

    5. Dinani ndi kusunga makiyi a Ctrl pa makiyi.

    6. Sakanizani ndi kutulutsa chilembo " Z " pa makiyi.

    7. Deta mu selo iyenera kusinthira kubwerera kumanzere pamene kusinthika kotsiriza (kuyanjana pakati) kudasinthidwa.

    8. Dinani ndi kusunga makiyi a Ctrl pabokosilo kachiwiri.

    9. Dinani ndi kumasula chilembo " Z " pa kamphindi kawiri popanda kumasula makiyi a Ctrl .

    10. Siketi yokhayo idzachotsedwa koma foni siidzakhalanso Arial Black.

    11. Izi zimachitika chifukwa, monga tafotokozera pamwambapa, chiwonetsero cha "chotsitsa" zochita zanu mwachindunji chomwe munachigwiritsa ntchito.

    Zina Zovuta Zopangira Njira Zowonjezera

    Zambiri "

    09 pa 27

    Kusankha Maselo Osakhala Aakulu

    Kusankha Maselo Osakhala Aakulu. © Ted French

    Sankhani Maselo Osadziwika ku Excel

    Mauthenga Ogwirizana: Sankhani Maselo Osakhala Aakulu Pogwiritsira Ntchito Keyboard ndi Mouse

    Pogwiritsa ntchito maselo angapo mu Excel mungathe kuchotsa deta, kugwiritsa ntchito maonekedwe monga malire kapena shading, kapena kugwiritsa ntchito njira zina kumadera akulu a tsambali panthawi imodzi.

    Nthaŵi zina maselowa sapezeka pamalo ozungulira. Muzochitika izi ndizotheka kusankha osakhala pafupi ndi maselo.

    Izi zikhoza kuchitika pogwiritsa ntchito kibokosi ndi mbewa palimodzi kapena kugwiritsa ntchito kamphindi.

    Kugwiritsira ntchito Keyboard mu Njira Yowonjezera

    Kusankha maselo osakhala pafupi ndi kamphindi kokha kukufuna kuti mugwiritse ntchito makinawo mu Njira Yowonjezera .

    Njira yowonjezera imatsegulidwa mwa kukanikiza F8 key pa ikhibhodi. Mumatseka mawonekedwe otalikira mwa kukanikiza makiyi a Shift ndi F8 pa kibokosi pamodzi.

    Sankhani Maselo Osakwatiwa Osakhala Odziwika mu Excel Pogwiritsira Ntchito Keyboard

    1. Sungani selojekiti yanu ku selo yoyamba yomwe mukufuna kusankha.
    2. Dinani ndi kumasula f8 fungulo pa makina kuti muyambe Njira Yowonjezera ndikuwonetsa selo yoyamba.
    3. Popanda kusuntha cholozera cha selo, pezani ndi kumasula makiyi a Shift + F8 pa kibokosi pamodzi kuti mutsegule njira yowonjezera.
    4. Gwiritsani ntchito mafungulo pa makiyi kuti musunthire selojekiti ku selo yotsatira yomwe mukufuna kuti muyike.
    5. Selo yoyamba iyenera kukhala yosonyeza.
    6. Ndi selo ya selo pa selo yotsatira kuti iwonetseredwe, bweretsani masitepe 2 ndi 3 pamwambapa.
    7. Pitirizani kuwonjezera maselo ku mapulaneti ofunika kwambiri pogwiritsa ntchito mafungulo a F8 ndi Shift + F8 kuti muyambe ndi kuyima mawonekedwe opitilira.

    Kusankha Magetsi Osavuta ndi Osakhala Odziwika mu Excel Pogwiritsa Ntchito Keyboard

    Tsatirani ndondomeko ili m'munsiyi ngati mtundu umene mukufuna kuusankha uli ndi osakaniza a maselo omwe ali pafupi ndi omwe akuwonetsedwa pa chithunzi pamwambapa.

    1. Sungani selojekiti ku selo yoyamba mu gulu la maselo omwe mukufuna kuwunikira.
    2. Dinani ndi kumasula f8 fungulo pa khibhodi kuti muyambe Njira Yowonjezera .
    3. Gwiritsani ntchito makiyi a fungulo pa kibokosilo kuti muwonjezere mtundu womwe ulipo kuti muphatikize maselo onse mu gululo.
    4. Ndi maselo onse a gululo osankhidwa, pezani ndi kumasula makiyi a Shift + F8 pa kibokosi pamodzi kuti mutseke njira yowonjezera.
    5. Gwiritsani ntchito mafungulo pa makiyi kuti musunthire selololo kuchoka ku gulu la osankhidwa.
    6. Gulu loyambirira la maselo liyenera kukhala likuyikidwa.
    7. Ngati pali magulu ambiri omwe mumagwiritsa ntchito, mukufuna kusunthira ku selo yoyamba mu gulu ndikubwezeretsanso masitepe 2 mpaka 4 pamwambapa.
    8. Ngati pali maselo omwe mukufuna kuwonjezera pazithunzizi, gwiritsani ntchito malangizo oyambirira pamwambapa kuti muwonetsere maselo okhaokha.
    Zambiri "

    10 pa 27

    Sankhani Maselo Osadziwika ku Excel ndi Keyboard ndi Mouse

    Sankhani Maselo Osadziwika ku Excel ndi Keyboard ndi Mouse. © Ted French

    Mauthenga Ogwirizana: Kusankha Maselo Osakhala Aakulu Pogwiritsira Ntchito Keyboard

    Pogwiritsa ntchito maselo angapo mu Excel mungathe kuchotsa deta, kugwiritsa ntchito maonekedwe monga malire kapena shading, kapena kugwiritsa ntchito njira zina kumadera akulu a tsambali panthawi imodzi.

    Pogwiritsira ntchito kukoka kwadula ndi mbewa kuti muwonetsetse kuti maselo omwe ali pafupi ndi njira yofala kwambiri yosankhira selo imodzi, nthawi zina maselo omwe mukufuna kuwunikira sakupezeka pambali pawo.

    Izi zikachitika, ndizotheka kusankha maselo osayandikana nawo. Ngakhale kusankha maselo osakhala pafupi kungakhoze kuchitidwa kokha ndi kambokosi , ndi kosavuta kugwiritsa ntchito kambokosi ndi mbewa palimodzi.

    Kusankha Maselo Osakhala Aakulu mu Excel

    Pothandizidwa ndi chitsanzo ichi, onani chithunzi pamwambapa.

    1. Dinani pa selo yoyamba yomwe mukufuna kusankha ndi pointer ya mouse kuti mupange selo yogwira ntchito .

    2. Tulutsani batani la mouse.

    3. Dinani ndi kusunga makiyi a Ctrl pa makiyi.

    4. Dinani pa maselo ena onse omwe mukufuna kuwasankha Popanda kumasula makiyi a Ctrl .

    5. Pamene maselo onse okhudzidwa asankhidwa, kumasula makiyi a Ctrl .

    6. Musayang'ane kwina kulikonse ndi ndondomeko ya mouse pamene mutulutsira fungulo la Ctrl kapena mudzachotsa chodabwitsa kuchokera kumaselo osankhidwa.

    7. Ngati mutsegula makiyi a Ctrl mofulumira ndipo mukufuna kuwonetsa maselo ambiri, imanikani ndi kubwezeretsa makina a Ctrl kenaka dinani zina (s) zina.

    Zojambula Zina Zopangira Zopangira

    Zambiri "

    11 pa 27

    ALT - TAB Kusinthana mu Windows

    ALT - TAB Kusinthana mu Windows.

    Osangokhala njira yokhayokha ya Excel, ALT - TAB Kusinthasintha ndi njira yofulumira yosunthira pakati pa maofesi onse otsegula ku Windows (Win key + Tab mu Windows vista).

    Kugwiritsira ntchito kibokosi kuti muchite ntchito pamakompyuta nthawi zambiri kumakhala kovuta kwambiri kuposa kugwiritsa ntchito mbewa kapena chipangizo china cholozera, ndipo ALT - TAB Kusinthasintha ndi chimodzi mwa njira zomwe zimagwiritsidwa ntchito kwambiri ndi zidulezi.

    Kugwiritsa ntchito ALT - TAB Kusinthana

    1. Tsegulani osachepera awiri mawindo mu Windows. Izi zingakhale mafayela awiri a Excel kapena File Excel ndi fayilo ya Microsoft Word mwachitsanzo.

    2. Lembani ndi kugwiritsira chingwe cha Alt pa makiyi.

    3. Sakanikizani ndi kumasula makiyi a Chikho pamakinawo popanda kulola kuti mutsegule .

    4. The ALT - TAB Fast Switching window ayenera kuonekera pakati pa pulojekiti yanu.

    5. Fenera ili liyenera kukhala ndi chithunzi cha chikalata chilichonse chomwe chikugwiritsidwa ntchito pa kompyuta yanu.

    6. Chojambula choyamba kumanzere chidzakhala cha chikalata chomwe chilipo - chomwe chikuwoneka pawindo.

    7. Chithunzi chachiwiri kuchokera kumanzere chiyenera kufotokozedwa ndi bokosi.

    8. Pansi pa zithunzi muyenera kukhala dzina la chikalata chomwe chili ndi bokosi.

    9. Tulutsani makiyi a Alt ndi mawindo akusinthirani ku chilemba chowonekera.

    10. Kuti mupite ku malemba ena owonetseredwa pawindo la ALT - TAB Fast Switching, pitirizani kulepheretsa Alt pamene mukugwiritsira ntchito makiyi. Pampu iliyonse iyenera kusuntha bokosi lopambana lomwe limachoka kumanzere kuchoka ku chigawo chimodzi kupita ku china.

    11. Tsetsani fungulo la Alt pamene chilemba chofunidwa chikuwonekera.

    12. Pamene ALT - TAB Fast Switching window yatseguka, mutha kuyimitsa kutsogolo kwa bokosi lopambana - kuliyendetsa kuchoka kumanja kupita kumanzere - pokhala pansi pa key Shift komanso ku Alt ndiyeno kugwiritsira chingwe.

    Zowonjezera Zowonjezera Zida

    Zambiri "

    12 pa 27

    Pitani ku mitu ya Excel

    Pitani ku mitu ya Excel.

    Mauthenga ogwirizana: Excel Name Box Navigation .

    The Go To feature in Excel angagwiritsidwe ntchito mwamsanga kupita kumaselo osiyana mu spreadsheet . Nkhaniyi ikuphatikizapo momwe mungagwiritsire ntchito Go Kuti muzisuntha kupita ku maselo osiyanasiyana pogwiritsa ntchito njira yachinsinsi.

    Ngakhale kuti sikoyenera ku mapepala omwe amagwiritsa ntchito zigawo zingapo ndi mizere pang'ono , pamabuku akuluakulu angakhale othandiza kuti mukhale ndi njira zosavuta za kudumpha kuchokera kudera lina la tsamba lanu kupita ku lina.

    Kuti muyambe Kuyika kuti mugwiritse ntchito pogwiritsa ntchito keyboard, yesani F5

    Chitsanzo pogwiritsa ntchito Excel kupita Kuziyendetsa:

    1. Dinani fungulo la F5 pa kibokosilo kuti mubweretse kukambitsirana kolowera.
    2. Lembani mndandanda wa selo la malo omwe mukufuna kuti mulowetsedwe mu bokosi la bokosi. Pankhaniyi: HQ567 .
    3. Dinani pa batani loyenera kapena yesani ku ENTER kwa makiyi.
    4. Bokosi lakuda lomwe liri pafupi ndi selo yogwira ntchito liyenera kulumphira ku selo HQ567 kuti likhale selo yatsopano yogwira ntchito.
    5. Kuti mupite ku selo lina, bweretsani masitepe 1 mpaka 3.

    Zotsatira Zogwirizana

    Zambiri "

    13 pa 27

    Excel Lembani Lamulo Lansi

    Excel Lembani Lamulo Lansi.

    Ngati mukufuna kufotokoza deta yomweyi - malemba kapena manambala - mumaselo angapo pafupi ndi mzere , Fill Down command ikhoza kukuchitirani izi mwachangu pogwiritsa ntchito makiyi.

    Nthano iyi ya Excel ikuwonetsani momwe mungagwiritsire ntchito Lembetsani lamulo mu Excel spreadsheet pogwiritsa ntchito njira yomasulira.

    Mgwirizano wapadera umene umagwira Ntchito Yodzaza pansi ndi:

    Chitsanzo: Gwiritsani ntchito Zodzaza ndi Chotsatira Chophindikiza

    Pothandizidwa ndi chitsanzo ichi, onani chithunzi pamwambapa.

    1. Lembani nambala, monga 395.54 mu selo D1 mu Excel.

    2. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi
    3. Lembani ndi kugwiritsira ntchito fungulo la Down Arrow pa kibokosilo kuti mukulitse kuunika kwa selo kuchokera ku selo D1 mpaka D7.
    4. Tulutsani mafungulo onsewa.
    5. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
    6. Sakanizani ndi kumasula fungulo " D " pa kibokosilo.
    7. Maselo D2 ku D7 ayenera tsopano kudzazidwa ndi deta yomweyi monga selo D1.

    Zowonjezera Zowonjezera Zida

    Zambiri "

    14 pa 27

    Kugwiritsa ntchito Zowoneka Zokonzedwa

    Kugwiritsa ntchito Zowoneka Zokonzedwa.

    Nthano iyi ya Excel ikukuwonetsani momwe mungagwiritsire ntchito makina opangira mauthenga pogwiritsa ntchito njira zofikira pa makiyi.

    Pali njira ziwiri zomwe zingagwiritsidwe ntchito kuwonjezera kapena kuchotsa zitsulo zamatsenga zomwe zimapangidwira ku deta:

    Chitsanzo: Gwiritsani Ntchito Zowonjezera Zowonjezera Kugwiritsa Ntchito Zowonongeka

    Pothandizidwa ndi chitsanzo ichi, onani chithunzi kumanja.

    1. Lembani deta yanu mu selo , monga E1 mu spreadsheet ndikusindikizira Enter key pa makiyi.

    2. Dinani pa selo kuti mupange selo yogwira ntchito .

    3. Dinani ndi kusunga makiyi a Ctrl pa makiyi.

    4. Dinani ndi kumasula kalata " I " pa kambokosi.

    5. Mitengo yowonjezera iyenera kugwiritsidwa ntchito ku deta mu selo.

    6. Sakanizani ndi kumasula makiyi a Ctrl + " I " kachiwiri kuti muchotse zojambulajambulazo.

    Zowonjezera Zowonjezera Zida

    15 pa 27

    Ikani Kujambula kwa Namba

    Ikani Kujambula kwa Namba.

    Phunziroli likufotokoza mmene mungagwiritsire ntchito ma nomiti osankhidwa pogwiritsa ntchito makina awa:

    Maonekedwe a chiwerengero chogwiritsidwa ntchito pa deta yosankhidwa ndi awa:


    Mgwirizano waukulu womwe ungagwiritsidwe ntchito kugwiritsa ntchito ndalama kupanga ma data ndi:

    Ctrl + Shift + ! (mawu okweza)

    Chitsanzo: Gwiritsani Ntchito Zowonjezera Zowonjezera Kugwiritsa Ntchito Kujambula Nambala

    Chitsanzo ichi chikuwonetsedwa mu chithunzi pamwambapa


    1. Onjezani deta zotsatirazi ku maselo A1 mpaka A4:
      4578.25102 45782.5102 457825.102 4578251.02
    2. Sungani maselo A1 ku A4 kuti muwasankhe
    3. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi
    4. Sindikirani ndi kumasula fayilo yachinsinsi ( ! ) Pa kibokosi popanda kumasula makiyi a Ctrl ndi Shift
    5. Tulutsani makiyi a Ctrl ndi Shift
    6. Ziwerengero m'maselo A1 mpaka A4 ziyenera kupangidwa kuti ziwonetsedwe malo awiri okha ngakhale ziwerengero zingapo zili ndi zoposa ziwiri
    7. Maselo ayeneranso kukhala ndi comma yowonjezeredwa ngati wopatulira zikwi
    8. Kusindikiza pa maselo alionse akuwonetsa chiwerengero choyambirira chosasinthika mu barolo lazenera pamwamba pa tsamba

    Zowonjezera Zowonjezera Zida

    Zambiri "

    16 pa 27

    Ikani Kukonzekera kwa Ndalama

    Ikani Kukonzekera kwa Ndalama.

    Phunziroli limaphatikizapo momwe mungagwiritsire ntchito ndalama zowonongeka kwa maselo osankhidwa pogwiritsa ntchito kibokosilo:

    Mgwirizano waukulu womwe ungagwiritsidwe ntchito kugwiritsa ntchito ndalama kupanga ma data ndi:

    Chitsanzo: Gwiritsani Ntchito Zowonjezera Zowonjezera Kuti Muyike Kupanga Ma Currency

    Pothandizidwa ndi chitsanzo ichi, onani chithunzi kumanja.

    1. Onjezani deta zotsatirazi ku maselo A1 ku B2: 7.98, 5.67, 2.45, -3.92

    2. Kokani osankha maselo A1 ku B2 kuti awoneke.

    3. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.

    4. Limbikitsani ndi kumasula fayiloyiyi ( 4 ) pa kibokosi popanda kumasula makiyi a Ctrl ndi Shift .

    5. Mu maselo A1, A2, ndi B1 chizindikiro cha dola ( $ ) chiyenera kuwonjezedwa ku deta.

    6. Mu selo B2, chifukwa deta ndi nambala yolakwika, iyenera kukhala yofiira ndi kuzunguliridwa ndi mabwalo oyandikana kuphatikizapo kukhala ndi chizindikiro cha dola ( $ ).

    Zowonjezera Zowonjezera Zida

    Zambiri "

    17 pa 27

    Ikani mawonekedwe a Peresenti

    Ikani mawonekedwe a Peresenti.

    Nthano iyi ya Excel ikuphatikiza kugwiritsa ntchito maonekedwe a maselo kwa maselo osankhidwa mu Excel spreadsheet pogwiritsa ntchito makina osinthira pa makiyi.

    Mgwirizano waukulu womwe ungagwiritsidwe ntchito kugwiritsa ntchito ndalama kupanga ma data ndi:

    Chitsanzo cha Momwe Mungagwiritsire Ntchito Kupanga Mafomu Pogwiritsa Ntchito Zowonjezera Zake

    Pothandizidwa ndi chitsanzo ichi, onani chithunzi pamwambapa.

    1. Onjezani deta zotsatirazi ku maselo A1 mpaka B2: .98, -.34, 1.23, .03

    2. Kokani osankha maselo A1 ku B2 kuti awoneke.

    3. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.

    4. Dinani ndi kumasula foni zisanu ( 5 ) pa kibokosi popanda kumasula makiyi a Ctrl ndi Shift .

    5. Mu maselo A1 mpaka B2 deta iyenera kutembenuzidwira peresenti ndi chizindikiro cha peresenti ( % ) yowonjezera ku deta.

    Zojambula Zina Zopangira Zopangira

    Zambiri "

    18 pa 27

    Sankhani Maselo Onse mu Table Excel Data

    Sankhani Maselo Onse mu Table Excel Data.

    Nthano iyi ya Excel ikuphatikiza momwe mungasankhire maselo onse mu tebulo la deta la Excel pogwiritsa ntchito njira yomasulira. Kuchita zimenezi kumakulolani kuti mugwiritse ntchito kusintha monga kujambula, m'lifupi, ndi zina.

    Nkhani yowonjezera: Kupanga Deta Yachidule mu Excel .

    Dziwani: Pothandizidwa ndi chitsanzo ichi, onani chithunzi kumanja.

    Chitsanzo cha Momwe Mungasankhire Maselo Onse mu Tsamba la Deta

    1. Tsegulani tsamba la Excel lomwe liri ndi tebulo la deta kapena pangani tebulo la deta .

    2. Dinani pa selo iliyonse mu tebulo la deta.

    3. Dinani ndi kusunga makiyi a Ctrl pa makiyi.

    4. Dinani ndi kumasula chilembo " A " pa kibokosi popanda kumasula makiyi a Ctrl .

    5. Maselo onse mu tebulo la deta ayenera kuwonetsedwa.

    6. Dinani ndi kumasula kalata " A " kachiwiri.

    7. Mzere wotsatira wa tebulo la deta uyenera kuwonetsedwa pamodzi ndi tebulo la deta.

    8. Dinani ndi kutulutsa kalata " A " nthawi yachitatu.

    9. Maselo onse omwe ali pa worksheet ayenera kuwonetsedwa.

    Zowonjezera Zowonjezera Zida

    Zambiri "

    19 pa 27

    Sankhani Mzere Wonse ku Excel Pogwiritsa Ntchito Zowonjezera Zake

    Sankhani Mzere Wonse ku Excel Pogwiritsa Ntchito Zowonjezera Zake.

    Sankhani Mizere mu Tsamba la Ntchito

    Ndemanga ya Excelyi ikufotokoza momwe mungasankhire kapena kuika mzere mwatsatanetsatane muzomwe muli kugwiritsa ntchito pogwiritsa ntchito makina osatsekera pa kibokosilo mu Excel.

    Mgwirizano wambiri womwe umagwiritsidwa ntchito kusankha mzere ndi:

    SHIFANI + SPACEBAR

    Chitsanzo: Gwiritsani Ntchito Zowonjezera Makina Kusankha Mzere Wonse Wolemba Mapepala

    1. Tsegulani tsamba la Excel - sikuyenera kukhala ndi deta iliyonse
    2. Dinani pa selo pa tsamba - monga A9 - kuti mupange selo yogwira ntchito
    3. Sindikizani ndi kugwira chiyilo cha SHIFT pa kambokosi
    4. Sakanizani ndi kumasula fayilo ya SPACEBAR pabokosilo popanda kumasula fayilo SHIFT
    5. Tulutsani fungulo la SHIFT
    6. Maselo onse mu mzere wosankhidwa ayenera kuwonetsedwa - kuphatikizapo mutu wa mzere
    Zambiri "

    20 pa 27

    Sungani ku Excel

    Sungani ku Excel.

    Excel Pulumutsani Mafi Odule

    Nthano iyi ya Excel ikuphatikiza momwe mungasungire mwatsatanetsatane deta pogwiritsa ntchito makina osinthana pa kibokosi mu Excel.

    Mgwirizano waukulu womwe ungagwiritsidwe ntchito kusunga deta ndi:

    Ctrl + S

    Chitsanzo: Kugwiritsa Ntchito Zowonjezera Zowonjezera Kuti Muzisunga Khadi Labwino

    1. Dinani ndi kusunga makiyi a Ctrl pa makiyi
    2. Sindikirani ndi kumasula makalata ( S ) pa kibokosi popanda kumasula makiyi a Ctrl
    3. Tulutsani makiyi a Ctrl

    Sungani Nthawi Yoyamba

    Ngati mwasunga kale tsambali kuti chisonyezero chokha chimene Excel ikupulumutsira fayilo yanu ikhoza kukhala choyimira phokoso chimasintha mwachidule mu chithunzi cha hourglass ndikubweranso ku chizindikiro choyera choyera.

    Kutalika kwa nthawi chizindikiro cha hourglass chili chowoneka kumadalira kuchuluka kwa deta Excel iyenera kusunga. Powonjezera kuchuluka kwa deta kuti mupulumutse, chizindikiro chachikulu cha hourglass chidzawonekera.

    Ngati mukusunga fomu yoyamba kwa nthawi yoyamba bokosi la Gulu la Asakatulo lidzatsegulidwa.

    Pamene fayilo imasungidwa kwa nthawi yoyamba mfundo ziwiri ziyenera kufotokozedwa mu bokosi la Save As dialog:

    Sungani Nthawi Zambiri

    Popeza kugwiritsa ntchito makina oyimbilira a Ctrl + S ndi njira yosavuta yosungira deta ndilo lingaliro lopulumutsa nthawi zambiri - mphindi zisanu iliyonse - kupeŵa kutaya deta ngati kompyuta ikuwonongeka. Zambiri "

    21 pa 27

    Bisani ndikugwirizanitsa zipilala ndi mizere mu Excel

    22 pa 27

    Kukonza Tsiku

    Kukonza Tsiku.

    Nthano iyi ya Excel ikuwonetsani momwe mungasinthire tsiku (tsiku, mwezi, chaka chapamwamba) mu Excel spreadsheet pogwiritsa ntchito njira yomasulira.

    Kukonza Tsikulo pogwiritsa ntchito Keyboard Shortcut

    1. Onjezerani tsiku lofunidwa ku selo mu Excel spreadsheet.

    2. Dinani mu selo kuti mupange selo yogwira ntchito .

    3. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.

    4. Dinani ndi kumasula fungulo lachizindikiro ( # ) pabokosilo popanda kumasula makiyi a Ctrl ndi Shift .

    5. Tsiku la selo yogwira ntchito lidzapangidwe tsiku, mwezi, chaka.

    Zowonjezera Zowonjezera Zida

    Zambiri "

    23 pa 27

    Kukonza Nthawi Yake

    Kukonza Nthawi Yake.

    Nthano iyi ya Excel ikukuwonetsani momwe mungasinthire nthawi yeniyeni (ora, miniti, ndi AM / PM maonekedwe) mu tsamba la Excel pogwiritsa ntchito njira yachinsinsi.

    Kukonza Nthawi Yamakono pogwiritsa ntchito Keyboard Shortcut

    1. Gwiritsani ntchito MASIKU ano kuti muwonjezere tsiku ndi nthawi yeniyeni ku selo D1.

    2. Dinani pa selo D1 kuti mupange selo yogwira ntchito .

    3. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.

    4. Dinani ndi kumasula chiwerengerochi ( 2 ) pa kibokosi popanda kumasula makiyi a Ctrl ndi Shift .

    5. Zomwe zikugwira ntchito mu selo D1 zidzapangidwira kuti ziwonetse nthawi yeniyeni mu ora, miniti, ndi AM / PM maonekedwe.

    Zowonjezera Zowonjezera Zida

    Zambiri "

    24 pa 27

    Sinthani Pakati Patsiku

    Sinthani Pakati Patsiku.

    Monga njira yogwiritsira ntchito mbewa, ndi zophweka kugwiritsa ntchito njira yachinsinsi kuti musinthe pakati pa maofesi ku Excel.

    Mafungulo ogwiritsidwa ntchito ndi key CTRL kuphatikizapo PGUP (tsamba pamwamba) kapena PGDN (tsamba pansi) key



    Chitsanzo - Sinthani Pakati pa Ma Worksheets mu Excel

    Kupita kumanja:

    1. Dinani ndi kugwira CTRL key pa makiyi.
    2. Dinani ndi kumasula fayilo la PGDN (tsamba pansi) pabokosilo.
    3. Kusuntha pepala lina kumakina abwino ndikumasula kachiwiri PGDN .

    Kupita kumanzere:

    1. Dinani ndi kugwira CTRL key pa makiyi.
    2. Dinani ndi kumasula fungulo la PGUP (tsamba pamwamba) pabokosilo.
    3. Kusuntha pepala lina kumanzere lakumanzere ndikumasula fungulo PGUP kachiwiri.

    Zowonjezera Zowonjezera Zida

    Zindikirani: Kusankha maofesi ambiri pogwiritsa ntchito makinawo, dinani: Ctrl + Shift + PgUp kusankha masamba kumanzere Ctrl + Shift + PgDn kuti musankhe masamba kumanja.

    25 pa 27

    Sungani maselo ndi F2 Function Key

    Sungani maselo ndi F2 Function Key.

    Chotsani Ma selo Njira Yowonjezera

    Mfungulo wa ntchito F2 umakulolani kuti musinthe mofulumira ndi kusinthasintha deta ya selo mwa kuyambitsa kusintha kwa Excel ndikuyika mfundo yolembera kumapeto kwa selo yogwira ntchito zomwe zilipo.

    Chitsanzo: Kugwiritsira ntchito F2 Key kuti Sungani Zamkatimu

    Chitsanzo ichi chikukhudza momwe mungasinthire ndondomeko mu Excel

    1. Lowani deta yotsatirayi mu maselo 1 mpaka D3: 4, 5, 6
    2. Dinani pa selo E1 kuti mupange selo yogwira ntchito
    3. Lowani ndondomeko zotsatirazi mu selo E1:
      = D1 + D2
    4. Lembani fungulo lolowamo lolowamo kuti mukwaniritse fomu - yankho 9 liyenera kuoneka mu selo E1
    5. Dinani pa selo E1 kuti mupangenso selo yogwira ntchito
    6. Dinani pa F2 key pa makiyi
    7. Excel imalowa muzolowera kusintha ndipo mfundo yoyikidwa imayikidwa kumapeto kwa njira yamakono
    8. Sinthani ndondomeko mwa kuwonjezera + D3 kumapeto kwake
    9. Lembani fungulo lolowamo mu Enter mu ikirubi kuti mutsirize ndondomekoyi ndi kusiya njira yosinthira - chiwerengero chatsopano cha fomu - 15 - chiyenera kuonekera mu selo E1

    Zindikirani: Ngati njira yothetsera kusintha mwachindunji m'maselo imatsekedwa, kukanikiza fichi ya F2 kudzaika Excel mu kusintha mode, koma tsamba lolowetsamo lidzasunthira ku bar lachonde pamwamba pa tsambali kuti mupange zomwe zili m'katimo. Zambiri "

    26 pa 27

    Sankhani Maselo Onse mu Pulogalamu Yolemba

    Sankhani Maselo Onse mu Pulogalamu Yolemba.

    27 pa 27

    Onjezani malire

    Onjezani malire.

    Nthano iyi ya Excel ikuphatikiza momwe mungapangire malire ku maselo osankhidwa mu Excel spreadsheet pogwiritsa ntchito njira yomasulira.

    Maphunziro okhudzana: Kuwonjezera / Kukonza Mapiri a Excel .

    Kuphatikizira kwawowonjezera nthawi ndi:

    Ctrl + Shift + 7

    Chitsanzo cha Momwe Mungakwirire Mapepala pogwiritsa ntchito Keyboard Shortcut

    Pothandizidwa ndi chitsanzo ichi, onani chithunzi kumanja.

    1. Lowani manambala 1 mpaka 9 mu maselo D2 mpaka F4.

    2. Kokani osankha maselo D2 ku F4 kuti awawonetsere.

    3. Dinani ndi kugwirizira makina a Ctrl ndi Shift pa makiyi.

    4. Dinani ndi kumasula fungulo seveni ( 7 ) pa kibokosi popanda kumasula makiyi a Ctrl ndi Shift .

    5. Maselo D2 ku F4 ayenera kuzungulira ndi malire akuda.


    Zowonjezera Zowonjezera Zida

    Zambiri "