Tsim cov xaus-rau-kawg kab hauv Microsoft Excel

Pin
Send
Share
Send

Cov kab kawg mus rau qhov kawg yog cov ntaub ntawv uas nws cov ntawv raug tso tawm thaum daim ntawv luam tawm ntawm cov nplooj ntawv sib txawv ntawm tib qho chaw. Nws yog qhov yooj yim dua los siv cov cuab yeej no thaum sau cov npe ntawm cov rooj thiab cov ntawv sau. Nws kuj tseem siv tau rau lwm cov hom phiaj. Cia wb mus saib ua li cas koj tuaj yeem npaj cov ntaub ntawv xws li hauv Microsoft Excel.

Siv cov kab kawg-rau-kawg kab

Txhawm rau tsim cov kab ntawv dhau los uas yuav ua rau txhua nplooj ntawv ntawm cov ntawv, koj yuav tsum ua qee yam kev ua kom yuam kev.

  1. Mus rau hauv lub tab Nplooj Phaj NtawvCov. Ntawm txoj hlua rau ntawm pob khawm Nplooj Ntawv Chaw nyem rau ntawm lub pob Luam Ntawv Hauv Paus.
  2. Saib xyuas! Yog tias koj tab tom kho cell, lub pob no yuav tsis ua haujlwm. Yog li ntawd, tawm txoj kev hloov kho hom. Tsis tas li, nws yuav tsis ua haujlwm yog tias lub tshuab luam ntawv tsis nruab rau hauv lub computer.

  3. Cov kev xaiv qhib qhov rai. Mus rau hauv lub tab Ntawv ntawvyog hais tias lub qhov rais qhib hauv lwm tab. Hauv cov chaw thaiv "Luam tawm ntawm txhua nplooj ntawv" muab tus cursor tso rau tom teb Cov kab kawg-rau-kawg kab.
  4. Tsuas yog xaiv ib lossis ntau kab rau ntawm daim ntawv uas koj xav ua kom kawg-rau-kawg. Lawv cov kev sib koom tes yuav tsum tau thawm rau hauv thaj chaw hauv lub qhov rai tsis suav. Nyem rau feem khawm "OK".

Tam sim no cov ntaub ntawv nkag rau hauv thaj chaw xaiv tseem yuav muab tso tawm rau lwm nplooj ntawv thaum luam ntawv, uas yuav txuag lub sijhawm ntau piv rau tib yam li koj sau thiab muab tso (tso) cov ntaub ntawv tseem ceeb ntawm txhua daim ntawv luam tawm cov khoom siv.

Txhawm rau pom cov ntawv zoo li cas thaum xa mus rau lub tshuab luam ntawv, mus rau ntawm lub tab Cov ntaub ntawv thiab tsiv mus nyob rau ntu ntawd "Luam Tawm"Cov. Nyob rau sab xis ntawm lub qhov rais, txav mus hauv qab daim ntawv, peb pom yuav ua li cas txoj haujlwm tau ua tiav tiav, uas yog, txawm hais tias cov ntaub ntawv los ntawm kab kawg-rau-kawg kab tshwm rau ntawm txhua nplooj ntawv.

Ib yam li ntawd, koj tuaj yeem tsim tsis tsuas yog kab, tab sis kuj kab. Tsuas yog nyob rau hauv cov ntaub ntawv no, kev koom tes yuav tau nkag mus rau hauv qhov chaw Los Ntawm Txhua hauv kab ntawv xaiv qhov rai.

Cov txheej txheem ua ke no yog siv rau cov qauv ntawm Microsoft Excel 2007, 2010, 2013 thiab 2016. Cov txheej txheem hauv lawv yog qhov zoo ib yam.

Raws li koj tuaj yeem pom, qhov kev pab cuam Excel muab lub peev xwm rau qhov yooj yim heev txhim kho los ntawm kab hauv phau ntawv. Qhov no yuav ua rau koj pom cov npe duplicate rau nplooj ntawv sib txawv ntawm daim ntawv, sau lawv ib zaug xwb, uas yuav txuag lub sijhawm thiab kev rau siab.

Pin
Send
Share
Send