Ukusebenzisa i-Excel Shortcut to Add a Worksheets

Ngubani owaziyo ukuba oku kulula ukwenza?

Njengokuba kukho ezininzi ze-Excel, kukho iindlela ezininzi zokufakela enye i- sheetsheetwork worksheets kwincwadi yokusebenzela ekhoyo.

Nayi imiyalelo yeendlela ezintathu ezahlukeneyo:

1. Ukusebenzisa izitshixo ezimfutshane kwikhibhodi.
2. Ukusebenzisa imouse kunye nephepha lethebhu.
3. Ukusebenzisa iindlela ezikhethiweyo kwikhaya lasekhaya lebhebhoni .

Faka iNew Worksheet usebenzisa Iqhosha leKhobhodi yekhibhodi

Kukho ngokwenene idibaniso ebalulekileyo yekhibhodi yokufaka iphepha lokusebenzela elitsha kwi-Excel:

Shift + F11
okanye
Alt + Shift + F1

Umzekelo, ukufaka iphepha lokusebenzela nge Shift + F11:

1. Cinezela kwaye ubambe iqhosha leShift kwikhibhodi.
2. Cinezela kwaye ukhulule iqhosha le- F11 - elisezantsi kwinqanaba lombolo kwibhodibhodi.
3. Ukukhupha ikhiye yeShift .
4. Iphepha lokusebenzela elitsha liya kufakwa kwincwadi yokusebenza yangoku kunene kuwo onke amaxwebhu okusebenzela.
5. Ukongeza ii-worksheets ezininzi ziqhubeka ukunyakraza nokukhupha iqhosha le- F11 ngelixa ubambe iqhosha leShift .

Faka iiWindows Worksheets usebenzisa Iqhosha eliKhobhodi

Ukongeza ii-worksheets eziliqela ngexesha elinye usebenzisa iifomfayile zebhobho ezi ngasentla, kufuneka uqale ugxininise inani leeteksi zokusebenzela ezikhoyo ukuxela i-Excel ukuba zingaphi ezinye iishishiti ezongeziweyo ngaphambi kokuba ufake ikhefu

Qaphela: Iithebhu ezikhethiweyo zetekethi kufuneka zibe kufuphi nomnye kule ndlela yokusebenza.

Ukukhetha amaphepha amaninzi kunokwenziwa ngeShift iqhosha kunye nemouse okanye enye yale miqhosha yebhobhobhodi:

Ctrl + Shift + PgDn - ukhetha amashidi ngakwesokudla.
Ctrl + Shift + PgUp - ukhetha amashidi ngakwesobunxele.

Umzekelo, ukufaka ezintathu zephepha lokusebenzela:

1. Cofa kwelinye ithebhu yomsebenzi kwincwadi yokusebenzela ukuyiqokomisa.
2. Cinezela kwaye ubambe iqhosha le Ctrl + Shift kwibhodibhodi.
3. Cinezela kwaye ukhulule ukhiye we- PgDn kabini ukugqamisa iifayile ezimbini ukuya ngasekunene-amaphepha amathathu kufuneka ngoku ngokugqitywa.
4. Landela imiyalelo engenhla ngokufaka ama-worksheets usebenzisa iShift + F11.
5. Amatsha omsebenzi omathathu kufuneka afakwe kwincwadi yokusebenzela ukuya ngasekunene kuzo zonke iifom.

Faka ii-Worksheets ezintsha ze-Excel usebenzisa iMouse kunye neTebhu zeTebhu

Ukongeza ishidi elilodwa lomsebenzi usebenzisa mouse, nqakraza kwi icon entsha ye-Sheet esekelwe kwiphepha leshidi ngaphantsi kwesikrini sase-Excel, njengoko kuboniswe kumfanekiso ongentla.

Kwi-Excel ka-2013, isithonjana esitsha sephepha isisayina esibonakalisiweyo njengoko kuboniswe kumfanekiso wokuqala ngenhla. Kwi-Excel 2010 kunye no-2007, i-icon ngumfanekiso wesikhewu somsebenzi kodwa isekelwe ngasecaleni kwamathebhu kwiphepha.

Iphepha elitsha lifakwe kwi-right of shee esebenzayo .

Faka ii-Worksheets Worksheets ezininzi usebenzisa iiTebhu zeTekethi kunye neMouse

Ngoxa kunokwenzeka ukongeza ii-worksheet ezininzi ngokuchofoza amaxesha amaninzi kwi icon entsha yephepha, enye inketho kuku:

1. Cofa kwiphepha elilodwa ukuze ukhethe.
2. Cinezela kwaye ubambe iqhosha leShift kwikhibhodi.
3. Cofa kwiibhokisi ezongezelelweyo ezisezantsi ukuze uzinqamlekise - gxininisa inani elifanayo leemakhishithi njengamaxwebhu amasha ukuba ungeze.
4. Nqakraza ngakwesinye sezikhethi ezikhethiweyo ukuvula ibhokisi yencoko yokufaka.
5. Cofa kwi icon ye Worksheet kwibhokisi yencoko yebabhokisi.
6. Cofa u- OK ukongeza amaphepha amatsha uze uvale ibhokisi yencoko.

Amaphepha omsebenzi omtsha aya kudibaniswa ngakwesokudla kuwo onke amaxwebhu okusebenzela.

Faka iNew Worksheet usebenzisa iRibhoni

Enye indlela yokongeza iphepha lokusebenzela elitsha kukusebenzisa inketho yokufaka efakwe kwithebhu yaseKhaya yedbhoni:

1. Cofa kwiThebhu yasekhaya yerbhoni.
2. Cofa kwi icon ye- Faka ukuze uvule imenyu ehlayo yokukhetha.
3. Cofa ku Faka iShidi ukuze ungeze iphepha elitsha ngakwesobunxele kwiphepha elisebenzayo.

Faka ii-Worksheets Worksheets ezininzi usebenzisa iRibhoni

1. Landela amanyathelo 1 ukuya ku-3 ngasentla ukwenzela ukuba ukhethe inani elifanayo lamaphepha ephepha njengamaphepha amasha okuza kudibaniswa.
2. Cofa kwiThebhu yasekhaya yerbhoni.
3. Cofa kwi icon ye- Faka ukuze uvule imenyu ehlayo yokukhetha.
4. Cofa ku Faka iShidi ukuze ungeze iifayile ezisebenzayo ezisekhohlo kwiphepha elisebenzayo.