Yuav Paub
- Add one worksheet: Nias Shift+ F11 los yog xaiv Plus (+) tom ntej mus rau lub tabs. Los yog mus rau Home > Insert > Insert Sheet.
- Ntxiv ntau daim ntawv: Nyem Ctrl+ Shift+ PgDn (txoj cai) lossis Ctrl+ Shift+ PgUp (sab laug) xaiv cov ntawv ua haujlwm uas nyob ib sab, tom qab ntawd nias Shift + F11.
- Los yog xaiv ib daim ntawv, nias thiab tuav Ctrl, xaiv cov ntawv uas nyob ib sab, tom qab ntawd nyem rau ntawm lub tab kawg thiab xaiv Insert > Daim Ntawv > OK.
Kab lus no piav qhia yuav ua li cas ntxiv cov ntawv ua haujlwm tshiab rau koj phau ntawv ua haujlwm Excel sai thiab yooj yim siv cov keyboard thiab nas shortcuts. Cov lus qhia npog Excel 2019, 2016, 2013, 2010, thiab 2007.
Insert Ib Daim Ntawv Ua Haujlwm nrog Keyboard Shortcuts
Muaj ob qhov sib txawv ntawm cov keyboard sib txawv uas koj tuaj yeem siv los ntxig cov ntawv ua haujlwm tshiab hauv Excel: Shift+ F11 thiabAlt +Shift +F1. Xaiv cov keyboard shortcut uas yooj yim tshaj rau koj nkag mus.
Txhawm rau ntxig daim ntawv ua haujlwm siv Shift+ F11, ua raws li cov kauj ruam no:
- Nias thiab tuav lub Shift tus yuam sij ntawm cov keyboard.
- Nias thiab tso tus F11 tus yuam sij.
-
Tshuaj rau Shift tus yuam sij. Daim ntawv tshiab tau muab tso rau hauv phau ntawv ua haujlwm tam sim no rau sab laug ntawm txhua daim ntawv ua haujlwm uas twb muaj lawm.
Image -
Txhawm rau ntxiv ntau daim ntawv ua haujlwm, nias Shift+ F11 rau txhua daim ntawv ua haujlwm ntxiv.
Ntxig ntau daim ntawv ua haujlwm nrog cov keyboard shortcuts
Txhawm rau ntxiv ntau daim ntawv ua haujlwm ib zaug siv cov keyboard shortcuts saum toj no, qhia cov lej ntawm cov ntawv ua haujlwm uas twb muaj lawm los qhia Excel seb yuav muaj pes tsawg daim ntawv tshiab ntxiv ua ntej siv cov keyboard shortcut.
Cov ntawv teev cov ntawv xaiv yuav tsum nyob ib sab rau ib leeg rau txoj haujlwm no.
Xaiv ntau nplooj ntawv, siv tus yuam sij ua haujlwm thiab koj tus nas lossis siv ib qho ntawm cov keyboard shortcuts:
- Ctrl+ Shift+ PgDn xaiv cov nplooj ntawv mus rau sab xis.
- Ctrl+ Shift+ PgUp xaiv cov nplooj ntawv rau sab laug.
Nov yog ib qho piv txwv ntawm yuav ua li cas ntxig peb daim ntawv ua haujlwm tshiab:
- Xaiv ib daim ntawv ua haujlwm hauv phau ntawv ua haujlwm kom pom nws.
-
nias thiab tuav Ctrl+ Shift.
- Nias thiab tso tus PgDn tus yuam sij ob zaug kom pom ob nplooj ntawv rau sab xis. Peb cov nplooj ntawv tseem ceeb.
- Nias Shift+ F11 txhawm rau ntxig cov ntawv ua haujlwm tshiab (saib cov lus qhia saum toj no yog tias koj xav tau kev pab). Peb daim ntawv ua haujlwm tshiab tau ntxiv rau hauv phau ntawv ua haujlwm rau sab laug ntawm daim ntawv ua haujlwm uas twb muaj lawm.
Insert Single Worksheets With the Sheet Tabs
Txhawm rau ntxiv ib daim ntawv ua haujlwm uas siv tus nas, xaiv Plus (+) icon nyob ib sab ntawm daim ntawv tab hauv qab ntawm Excel screen. Daim ntawv tshiab tau muab tso rau sab xis ntawm daim ntawv tam sim no.
Hauv Excel 2010 thiab 2007, Daim Ntawv Tshiab icon yog ib daim duab ntawm daim ntawv ua haujlwm tab sis nws tseem nyob ntawm ib sab ntawm daim ntawv tab hauv qab ntawm qhov screen.
Ntxig Ntau Daim Ntawv Ua Haujlwm Nrog Daim Ntawv Tabs
Thaum nws muaj peev xwm ntxiv ntau daim ntawv ua haujlwm los ntawm xaiv Daim Ntawv Tshiab ob peb zaug, nws muaj lwm txoj hauv kev los siv lub thawv sib tham. Nrog rau txoj kev no, cov ntawv ua haujlwm tshiab tau ntxiv rau sab xis ntawm txhua daim ntawv ua haujlwm uas twb muaj lawm.
Siv lub Insert dialog box ntxiv ntau daim ntawv ua haujlwm:
- Xaiv ib daim ntawv tab los qhia nws.
- Nias thiab tuav lub CTRL tus yuam sij.
- Xaiv cov ntawv nyob ib sab ntxiv kom pom lawv. Qhia kom meej tib tus lej ntawm daim ntawv tab raws li cov ntawv tshiab uas koj xav ntxiv.
-
Right-click rau ntawm daim ntawv kawg uas koj xaiv thiab xaiv Insert txhawm rau qhib qhov Insert dialog box.
Image -
Xaiv Worksheet hauv Insert dialog box, ces xaiv OK ntxiv cov nplooj ntawv tshiab thiab kaw lub dialog box.
Image
Insert Ib Daim Ntawv Ua Haujlwm Nrog Ribbon Bar
Lwm txoj hauv kev ntxiv cov ntawv ua haujlwm tshiab yog siv qhov Insert xaiv nyob rau ntawm Lub Tsev tab ntawm ribbon bar hauv Excel. Yog tias koj txaus siab rau kev tswj hwm qhov muag, koj tuaj yeem pom qhov kev xaiv no yooj yim tshaj plaws.
Ua raws cov kauj ruam no txhawm rau ntxig ib daim ntawv ua haujlwm uas siv Insert command:
- Xaiv lub Home tab.
- Xaiv tus Insert drop-down xub qhib cov ntawv qhia zaub mov ntawm kev xaiv.
-
Xaiv Insert Sheet ntxiv ib daim ntawv tshiab rau sab laug ntawm daim ntawv nquag.
Image
Insert ntau daim ntawv ua haujlwm nrog Ribbon Bar
Nws tseem tuaj yeem ntxig ntau daim ntawv ua haujlwm siv Insert command ntawm lub ribbon bar. Nov yog li cas:
- Xaiv ib daim ntawv tab los qhia nws.
- Nias thiab tuav lub CTRL tus yuam sij.
- Xaiv ntxiv daim ntawv uas nyob ib sab txhawm rau qhia lawv. Qhia kom meej tib tus lej ntawm daim ntawv tab raws li cov ntawv tshiab uas koj xav ntxiv.
-
Xaiv lub Home tab.
Image - Xaiv tus Insert drop-down xub qhib cov ntawv qhia zaub mov ntawm kev xaiv.
-
Xaiv Insert Sheet txhawm rau ntxiv cov ntawv ua haujlwm tshiab rau sab laug ntawm daim ntawv nquag.
Image
