Puas piv ob cov ntaub ntawv Excel li cas?

Cov txheej txheem:

Puas piv ob cov ntaub ntawv Excel li cas?
Puas piv ob cov ntaub ntawv Excel li cas?
Anonim

Sib piv ob phau ntawv Excel

  1. Click Home > Sib Piv Cov Ntaub Ntawv. …
  2. Nias lub khawm xiav icon nyob ib sab ntawm lub npov Sib piv los mus rau qhov chaw ntawm cov ntawv ua ntej ntawm koj phau ntawv ua haujlwm.

Kuv puas tuaj yeem piv ob daim ntawv Excel rau qhov sib txawv?

Nrog qhov 'Saib Ib Sab' kev xaiv, koj tuaj yeem sib piv ob daim ntawv Excel ntawm ib qho mus. Nyob rau hauv rooj plaub koj muaj ntau cov ntaub ntawv Excel qhib, thaum koj nyem rau ntawm qhov kev xaiv Saib Sab los ntawm Sab, nws yuav qhia koj lub 'Sib Sib Piv Ntawm Ib Sab' dialog box, qhov twg koj tuaj yeem xaiv cov ntaub ntawv twg koj xav sib piv nrog cov ntawv ua haujlwm nquag.

Koj ua li cas thiaj kuaj tau yog tias ob daim ntawv Excel zoo ib yam?

Sib piv Ob Daim Ntawv Excel

Txoj hauv kev zoo tshaj plaws los saib yog tias ob daim ntawv Excel yog qhov sib tw tiag tiag yuav yog tshuaj xyuas qhov sib txawv ntawm qhov muaj nqis. Yog tsis pom qhov sib txawv, lawv zoo ib yam. Tam sim no, luam tawm cov qauv no thiab mus rau sab xis siv Fill handle (ib lub xwmfab me me ntawm lub kaum sab xis hauv qab ntawm tes).

Kuv yuav saib ob daim ntawv Excel li cas?

Saib ob daim ntawv ua haujlwm hauv tib phau ntawv ua haujlwm ib sab

  1. Nyob ntawm Saib tab, hauv pab pawg qhov rai, nyem qhov rai tshiab.
  2. Nyob ntawm Saib tab, hauv pawg qhov rai, nyem Saib Ib sab.
  3. Nyob rau hauv txhua lub qhov rais phau ntawv ua haujlwm, nyem daim ntawv uas koj xav muab piv.
  4. Txhawm rau rub ob daim ntawv ua haujlwm tib lub sijhawm, nyem Synchronous Scrolling.

Kuv puas tuaj yeem qhib 2 Excel daim ntawv nthuav qhia ntawmtib lub sij hawm?

Nyob ntawm Saib tab, hauv pawg Qhov rai, nyem Saib Ib sab. Nyob rau hauv lub qhov rais phau ntawv ua hauj lwm, nyem cov ntawv ua hauj lwm uas koj xav muab piv. Txhawm rau rub ob daim ntawv ua haujlwm tib lub sijhawm, nyem Synchronous Scrolling hauv pawg Qhov rai ntawm Saib tab.

Pom zoo: