20 tricks yuav ua rau koj ib tug guru Excel

Txhua tus neeg uas ua hauj lwm rau ib lub computer, teb nyob rau hauv lub affirmative, Yog hais tias koj nug nws seb nws paub yuav ua li cas mus ua hauj lwm nyob rau hauv Excel. Txawm li cas los, Yog hais tias koj muab tso rau cov nqe lus nug lwm txoj kev thiab sim kom paub seb yuav ua li cas zoo, feem ntau ntawm nws yuav ua rau tsis meej pem. Tiam sis yuav tau kam? Nyob rau hauv qhov tseeb, qhov kev pab cuam khw muag khoom ib tug lossis loj npaum li cas ntawm secrets, uas koj tsuas tsis them sai sai. Tab sis yog tias koj paub txog lawv, lawv tam sim ntawd ua koj nyiam. Yog li ntawd, nyob rau hauv no tsab xov xwm koj yuav kawm txog nees nkaum txawv tricks nyob rau hauv "Eksele" uas txhua leej txhua tus yuav tsum paub.

Xaiv tag nrho nrog ib tug nias

Nyob rau hauv lub Upper rau sab laug ces kaum ntawm lub teb muaj ib lub pob uas tsis muaj ib tug feem ntau tsis nias. Thiab nws yog heev pab tau, raws li nws tso cai rau ib tug-click xaiv tag nrho cov hlwb ntawm qhov tam sim no cov ntaub ntawv.

Qhib ntau yam ntaub ntawv

Cov ntaub ntawv ua - qhov no yog qhov tseem ceeb feature ntawm qhov kev pab cuam, tab sis yuav ua li cas yog tias koj muaj dozens ntawm cov ntaub ntawv, txhua yam uas koj yuav tau siv? Tiag nws yog tsim nyog los qhib txhua ntawm lawv nyias? Nyob rau hauv qhov tseeb, muaj ib tug ua kom yuam kev uas yuav tso cai rau koj mus rau tiv nrog neeg ua hauj lwm sai. Xaiv tag nrho cov ntaub ntawv koj xav tau thiab nias lub Sau - tag nrho lawv qhib uas tsis muaj teeb meem nruab nrab ntawm lawv.

Scroll los ntawm cov ntaub ntawv

Thaum koj ua hauj lwm nrog ib tug loj tus naj npawb ntawm cov ntaub ntawv, heev npaum li cas yuav chim siab yuav tsum tau mus manually hloov ntawm lawv. Koj yuav ua rau koj lub neej yooj yim los ntawm kev siv tus yuam sij ua ke Ctrl + Tab, uas cia li keyboards koj mus rau lub tom ntej no tab.

ntawv qhia zaub mov khoom

Muaj coob tus ntseeg hais tias cov "Txuag", "Forward" thiab "Rov qab" - cov no yog cov tsuas xaiv muaj nyob rau hauv qhov kev pab cuam los ntawm cov saum toj kawg nkaus ntawv qhia zaub mov. Tab sis koj muaj peev xwm kuj ntxiv lawv rau leej twg nab npawb ntawm cov kev khiav dej num los ntawm ib tug tshwj xeeb thaiv tej chaw - cia li nco ntsoov tias daim ntawv yog tso tawm kom pom tsuas yog ob tug - tus so yuav tsum tau muab zais.

Cov kab pheeb ces kaum kab nyob rau hauv lub cell

Tej zaum koj yuav tau teem lub cell kab pheeb ces kaum kab qhia ntxiv, hloov mus rau nws. Tab sis yuav ua li cas ua tau nws? Tag nrho cov muaj peev xwm yuav txhais tau rau ib thaj tsam ntawm lub hlwb, tab sis yog tias koj tau nyem rau ntawm "Ntau ciam teb", koj yuav tau txais tsis yog ib tug kab pheeb ces kaum kab, tab sis kuj lwm surprises.

Ntxiv ntau kab los yog txhua

Sawv daws yeej paub yuav ua li cas ntxiv ib kab los yog sab ntawm lub hlwb. Tab sis ntxiv ib ob peb daim nyias - nws yog ib tug tiag tiag npau suav phem. Yog li ntawd, koj yuav zoo xaiv cov kev kawm tooj ntawm hlwb uas yuav sib haum mus rau qhov xav tooj ntawm kab los yog txhua, thiab ces rov hais dua cov txheej txheem lub lag luam.

Fast cov ntaub ntawv hloov lwm lub tsev

Yuav ua li cas yog tias koj xav tau kom sai tawm mus rau ib kem ntawm cov ntaub ntawv? Ua li no, tshem cov cursor rau ntawm ntug ntawm sab, kom txog rau thaum nws yuav siv sij hawm rau hauv daim ntawv ntawm tus ntoo khaub lig zoo li tus xub, ces txav tus txheem ntawm sab dawb do.

Tshem tawm ntawm khoob hlwb

Nyob rau hauv tus txheej txheem, heev feem ntau muaj yog ib tug loj tus naj npawb ntawm khoob hlwb, uas lwj lub tsos ntawm cov ntawv no. Koj yuav rho tawm lawv ib tug los ntawm ib tug - los yog siv ceev txoj kev. Ua li no, koj yuav tsum tau lim deselect cov khoom "Tag nrho" thiab xaiv "Npliag" - nws instantly xaiv tag nrho cov dawb paug hlwb nyob rau hauv cov ntaub ntawv uas koj yuav tshem tawm nrog ib tug nias.

tsis muaj tseeb kev tshawb fawb

Sawv daws yeej paub yuav ua li cas siv ib tug ceev mus nrhiav, tab sis ob peb cov neeg paub txog qhov tseeb hais tias koj yuav tsis mus nrhiav kom tau caij nyoog ntais ntawv, thiab cov kev tshwm sim ntawm ib tug los yog ntau tshaj cov tsiaj ntawv. Yog yuav tshawb kom rau ib tsab ntawv, koj yuav tsum mus rau hauv cov kev tshawb fawb bar rau nkag mus rau ib lo lus nug kos, thiab yog hais tias koj xav mus nrhiav los ntawm uas nkag mus rau ob peb tsiaj ntawv - Siv tus cim.

Tsim ib tug tshwj xeeb muaj nqis

Muaj coob tus neeg siv cov ntxaij lim dej, tab sis nws yuav luag yeej tsis saib nyob rau hauv theem siab. Tab sis nrog nws, koj yuav qhia ib tug tshwj xeeb muaj nuj nqis rau ib tug cell, Yog hais tias koj xav tau rau kev ua hauj lwm los yog rau lwm yam hom phiaj.

specification ntawm cov ntaub ntawv

Tsis yog txhua tus paub hais tias koj yuav teev txwv rau dab tsi cov ntaub ntawv yuav tsum muab ntaus rau hauv lub cell. Piv txwv li, yog tias koj tsim tau ib daim ntawv teev cov neeg raug caw tuaj koom rau cov kev tshwm sim, thiab lawv muaj hnub nyoog yuav yog los ntawm 18 mus rau 60 xyoo (tsuas tag nrho cov xov tooj), ces ob ntawm cov kev xaiv uas koj yuav xaiv los ntawm cov ntawv qhia zaub mov "Cov ntaub ntawv" thiab ces lwm tus qhov tseem ceeb tsuas yog yuav tsis tau txais .

ceev navigation

Rau ceev navigation ntawm daim ntawv page, koj siv tau cov Ctrl tseem ceeb nrog tus xib xub. Yog hais tias koj siv no thaum lawv tseem, koj mam li mus txog lub endpoint ntaub ntawv hlwb.

transformation

Tej zaum nws yog tsim nyog los tig sab nyob rau hauv ib tug kab, los yog vice versa. Nyob rau hauv qhov tseeb, nws muaj peev xwm yuav ua tau heev tsuas. Ua li no, koj yuav tau luam cov yam ntaub ntawv, thiab ces muab tshuaj txhuam nws los ntawm cov ntawv qhia zaub mov los ntawm kev xaiv "Hloov" - thiab koj tus xov tooj yuav tsum tau theej rau ib kem.

Yuav ua li cas nkaum qhov ntaub ntawv?

Nyob rau hauv "Eksele" muaj lub peev xwm mus zais cov lus qhia, tab sis nws yuav ua tau nyob rau hauv ntau txoj kev. Koj yuav tau nyem rau ntawm cov tes thiab xaiv "Hide", tab sis nws yuav tsis txhais tau tias qhov zoo tshaj plaws tshwm sim. Yog li ntawd nws yog pom zoo kom siv cell formatting rau hom hom ;;; - nws cia koj tau txais cov feem ntau txhim khu kev qha ntaub ntawv zais los ntawm prying ob lub qhov muag.

Combining cov ntaub ntawv los ntawm lub hlwb

Yog hais tias koj muaj ntau yam hlwb, thiab koj yuav tsum muab cov ntaub ntawv khaws tseg nyob rau hauv lawv mus rau hauv ib tug, koj yuav tsis tas tag nrho cov kev sau dua tshiab. Cia li teem lub muaj nuj nqi nyob rau hauv uas hlwb ntawm cov npe ntawm cov yuav tsum tau insert "ampersand" icon - cov nyob rau hauv lub xaiv ntawm tes, koj tau txais tag nrho cov ntaub ntawv los ntawm lub yav dhau los sawv daws yuav.

Hloov lowercase rau uppercase

Yog hais tias koj xav tau cov ntawv nyeem los ntawm ib tug ntawm tes los ua ib tug tag nrho sau nyob rau hauv capital tsiaj ntawv, koj tsis tas yuav retype nws tag nrog tshuab txais CapsLock. Koj cia li yuav tsum tau siv rau lub Upper muaj nuj nqi sau rau hauv qhia tau tias zoo li cas ntawm cell yuav tsum tau mus hloov.

Cov ntaub ntawv pib nrog 0

Nyob rau hauv tej rooj plaub, tej zaum koj yuav tsum sau cov ntaub ntawv rau hauv ib lub cell uas pib nrog 0. Tu siab, los ntawm neej ntawd hais, qhov kev pab cuam tau tshem tawm pes tsawg, tawm hauv tsuas yog ib tug integer nqi. Koj yuav tau hloov cov hom ntawv ntawm tus xovtooj ntawm, tab sis nws yog ib tug ntev txoj kev uas yog yooj yim los mus hloov ib tug yooj yim icon ib tsocai. Yog hais tias koj muab tso rau nws nyob rau hauv pem hauv ntej ntawm koj tus nqi, ces pes tsawg yuav nyob twj ywm rau hauv qhov chaw.

autocorrection

Muaj coob tus neeg siv AutoCorrect raws li tau npaj, uas yog tsis ntshai sau uas tsis, vim hais tias lawv paub hais tias lawv software yuav kho. Tab sis heev ob peb cov neeg tuaj mus mloog hais tias koj yuav siv qhov no feature mus piv rau nws cov neeg ua hauj lwm. Yog hais tias koj muaj rov muaj dua ntev lus, cov npe, ces koj yuav tau ntxiv rau lawv mus rau hauv daim ntawv ntawm cov lo lus rau autocorrection thiab siv lawv cov kev sau ntawv ntawm ib tug thib ob - thiab qhov kev pab cuam nws tus kheej yuav coj lawv mus rau hauv cov ntawv no, koj nug koj tus kheej ib zaug es tsis txhob ntawm ntau pua leej.

Yog xav paub ntxiv

Yog hais tias koj xaiv ib tug ntawm tes rau hauv lub sab ces kaum muaj yog cov ntaub ntawv hais txog nws. Txawm li cas los, nws yog nyob deb ntawm tiav, tab sis koj muaj peev xwm tau nkag mus rau kiag li tag nrho cov ntaub ntawv. Ua li no, koj yuav tsum yuj koj nas dua cov ntaub ntawv thiab nias rau ntawm txoj cai nas khawm - nws qhib ib lub qhov rais, uas yuav muaj tag nrho cov ntaub ntawv uas nyob rau hauv no xyov cell.

renaming nplooj ntawv

Ib tug ntawm cov nyuaj txoj kev, uas rau ib co yog vim li cas luag tsis muaj leej twg siv. Heev feem ntau, koj yuav tsum rename cov nplooj ntawv nyob rau hauv cov ntaub ntawv, thiab rau cov uas koj tau nyem rau ntawm lub npe, right-click, mam li xaiv "Rename", ces hloov lub npe. Tab sis cov txheej txheem yuav raug heev yooj yim zog los ntawm kev siv cov nplooj ntawv lub ntsiab cai tib yam li nrog shortcuts thiab cov ntaub ntawv nyob rau hauv lub qhov rais. Ob npaug nias rau lub npe ntawm cov nplooj ntawv muab koj ib tug instant sij hawm los mus kho kom raug thiab hloov tsis muaj kev ncua.