Microsoft Office Excel spreadsheet editor yog qhov siv ntau tshaj plaws hauv cov ntawv sau. Kev nkag mus rau cov ntaub ntawv rau hauv lub hlwb ntawm lub rooj nws tsim tuaj yeem nqa ob qho tib si los ntawm kev ntaus ntawv los ntawm cov keyboard, thiab los ntawm kev luam los ntawm qee qhov khoom sab nraud thiab dhau los rau hauv cov ntawv txheeb ntawm Excel cov ntaub ntawv. Txoj kev tom kawg tuaj yeem thov tsis yog rau cov ntaub ntawv ntau xwb, tab sis kuj tseem rau cov ntawv nyeem lub tiaj.
Tsim nyog
Tabular editor Microsoft Office Excel 2007 lossis 2010
Cov Lus Qhia
Kauj ruam 1
Los muab cov ntawv luam theej rau cov ntawv los teev cia rau hauv cov ntawv Excel ua haujlwm, qhib cov ntawv qhia zaub mov tseem ceeb hauv cov editor thiab hauv "Tsim" ntu xaiv "Phau ntawv tshiab" icon. Cov ntawv qhia zaub mov tseem ceeb hauv Excel 2007 tau qhib los ntawm nyem khawm Chaw Haujlwm khawm nyob rau sab saud sab sauv ntawm lub qhov rais, thiab xyoo 2010 nws hloov los ntawm lub pob ntsuab ntsuab lub cim sau npe ua File. Yog hais tias tus ntawv tshaj tawm qhov teeb meem tsis tau qhib, pib nws thiab phau ntawv tshiab yuav raug tsim los ua haujlwm.
Kauj ruam 2
Yog tias cov ntawv snippet theej rau hauv ntawv los teev cia yog cov ntawv sau yooj yim thiab tsis yog cov ntawv luam cov ntaub ntawv, tsuas yog nias Ctrl + V thiab kev ua haujlwm yuav ua tiav. Txawm li cas los xij, nco ntsoov tias txhua kab ntawv pom thaum lub sijhawm txheej txheem nkag yuav kho los ntawm Excel raws li kem delimiters thiab yuav tso cov ntawv txuas ntxiv rau hauv cov xovtooj ntawm kab tom ntej. Cov cim nqa khoom nqa rov qab tuaj yeem kho tau raws li kab sib cais. Yog tias qhov kev cuam tshuam ntawm no ntawm cov ntawv sau tawm ntawm tus qauv sau tsis haum koj, siv txoj kev muab tshuaj txhuam los ntawm cov kauj ruam tom ntej.
Kauj ruam 3
Qhib lub cell kho hom - nias rau "yuam sij kub" F2, lossis nyem ob npaug rau sab laug nas khawm ntawm lub xovtooj uas xav tau. Tom qab ntawd, zoo li hauv cov kauj ruam yav dhau los, siv cov ntawv cim luv + Ctrl + V los muab cov ntsiab lus ntawm daim ntawv txiav tawm. Txoj kev no tseem yog yooj yim rau kev luam cov ntawv rau hauv lub xovtooj ntawm lub rooj uas twb muaj lawm - los ntawm kev ua haujlwm zoo li no, kev ua haujlwm ntawm kab pauv hloov thiab kab ntawv yuav tsis raug yuam.
Kauj ruam 4
Yog tias cov ntawv theej tau tawg nyob hauv cov ntawv nyeem muaj qee cov ntaub ntawv, sib cais los ntawm tabs lossis lwm qhov sib cais, siv "Cov Ntawv Ntshuam Ntawm Cov Ntawv Sau". Qhib daim ntawv nco-down los ntawm nyem rau "Paste" khawm ntawm "Tsev" hauv "Clipboard" pab pawg hais kom ua thiab xaiv txoj kab nrog lub npe ntawm lub lwg no.
Kauj ruam 5
Ua raws li cov lus qhia - koj yuav kom koj xaiv cov kev xaiv sib txawv rau cov ntaub ntawv los ntawm cov ntawv sau, thiab qhov tshwm sim ntawm koj xaiv tuaj yeem pom hauv lub rooj hauv tib lub wizard window txawm tias ua ntej koj nyem lub pob mus rau theem tom ntej.
