Kuv yuav hloov ko taw thiab ntiv tes hauv Excel li cas?
Kuv yuav hloov ko taw thiab ntiv tes hauv Excel li cas?

Video: Kuv yuav hloov ko taw thiab ntiv tes hauv Excel li cas?

Video: Kuv yuav hloov ko taw thiab ntiv tes hauv Excel li cas?
Video: Cas Tsis Xaiv Koj - R-Lin Thoj New Song Original By Zaj Dub [Official MV] 2023 2024, Kaum ib hlis
Anonim

Yog li ntawd, peb ua tau hloov ntsuas ntsuas los ntawm ko taw rau nti los ntawm kev sib npaug 12. Kauj Ruam 1: Hauv CellC2 sau cov qauv = A2 * 12, thiab nias Enter. Kauj Ruam 2: Nyem rau ntawm Cell C2, luag cov ntawv sau hla cov kab uas koj yuav sau cov qauv no. Ces koj yuav pom tag nrho ko taw ntsuas yog hloov dua siab tshiab rau ntiv tes.

Kuj tseem paub yog, koj hloov ko taw thiab ntiv tes rau ntiv tes hauv Excel li cas?

Muaj 12 ntiv tes hauv a ko taw , yog li koj muab tus nqi los ntawm 12 mus rau hloov ko taw rau ntiv tes . Xwb, koj faib cov nti tus nqi los ntawm 12 rau hloov nws rau ko taw . Qhib qhov khoob Excel spreadsheet thiab sau ' Taw 'hauv cell B4 thiab' Ntiv 'hauv C4, uas yog ob kab lus.

Tsis tas li ntawd, kuv yuav ua li cas qhia ntiv tes hauv Excel? Siv cov ntsuas ntsuas ntawm ib daim ntawv ua haujlwm

  1. Ntawm Saib tab, hauv pawg Workbook Views, nyem PageLayout. Tswv yim: Koj tseem tuaj yeem nyem qhov Page Layout khawm ntawm qhov xwm txheej bar.
  2. Siv tus pas ntsuas kab rov tav thiab ntsug los ntsuas cov khoom hauv daim ntawv ua haujlwm (xws li kab dav, kab qhov siab, lossis qhov dav thiab qhov siab ntawm nplooj ntawv).

Tom qab ntawd, Kuv yuav hloov ko taw thiab ntiv tes rau ko taw hauv Excel li cas?

Sau "=RoundDown(A1, 0)" hauv cell B1 kom rho tawm tus lej ntawm ko taw . Hauv qhov piv txwv, cell B1 qhia "5." Enter"=Mod(A1, 1)*12" hauv cell C1 rau hloov cov seem rau hauv ntiv tes.

Yuav ua li cas hloov hauv Excel?

Tsuas yog ntaus "= Hloov pauv (" ua raws li tus nqi. Thaum koj nkag mus rau qhov comma kom txav mus rau ntu ntu ntawm txoj haujlwm, koj yuav pom cov npe ntawm cov chav nyob xaiv los ntawm hauv lub formulabar: Siv lub scrollbar los nrhiav koj chav tsev thiab ob npaug nias orclick + TAB to select it.

Pom zoo: