Excel furayaasha kulul (toobiye keyboard)

keyboard caawiyo dadka isticmaala si aan u fududeyno iyo dardar ay shaqada iyadoo la bedelayo falalka qaar ka mid ah. Tani waa ka sii muhiim u ah barnaamijyada xafiiska sida Microsoft Excel, taas oo loogu talagalay in lagu fududeeyo qof in ay la cayn kasta oo xogta u shaqeeyaan. Ka fiirso caan tuuryo keyboard, khuseyso in versions badan oo codsigan (ka Excel 2003 ilaa Excel 2013). Oo Excel 2003 jiraan isku si ha kula xidheen shalash shaqeeyo - si dhaqso ah u helaan guddi, tan iyo fursad this yimid oo kaliya ee Excel 2007 iyo waxaa laga heli karaa qoraalkii ka dib. Qaar ka mid ah isu-gaynta, kuwaas oo laga yaabaa in aan la versions goosgoos ah ayaa laga fekerayaa codsiyada shaqeeyaan.

Inta badan Excel furayaasha kulul oo caan ah

By riixaya, kuwaas oo isku muhiimka ah si ay u qabtaan hawlaha aasaasiga ah ee barnaamijka. Marka tilmaamay tuuryo keyboard "+" calaamad waxaa loo isticmaalaa si ay u muujiyaan ka olaleeyan ah, oo ku saabsan xaq u taagan oo ka tagay oo ka mid ah "+" calaamad. gaynta Key ayaa la tilmaamay in parentheses, waxaa laga yaabaa in mar sii cadaadisay, mid, laba, saddex ama xataa afar badhamada on keyboard ah. Sida caadiga ah, mid ka mid, laba ama saddex iyaga ka mid yihiin adeegyada muhiimka ah - Ctrl, Shift ama Alt. Waa inay jaraa'id hore iyo gobolka qaban hoos, saxaafadda kale (seddexaad ama afaraad) ee isku darka kulul oo muhiim ah.

waxaa lagama maarmaan ah in la abuuro file cusub, saxaafadda (Ctrl + N). Si aad si menu tagaan, ama la furo file a - (Ctrl + O), badbaadin faylka - (Ctrl + S), «Save sida» - (F12), Print - (Ctrl + P). Xir faylka - (Ctrl + F4). Active: baajiso - (Ctrl + Z), ku celi - (Ctrl + Y). Bilow abuuro of caanaha - (=). Xir faylka - (Alt + F4). Ku dar Column - (Ctrl + Shift + daray muhiimka ah). Geli warqada cusub - (Shift + F11). Challenge wada hadal miiska abuurka - (Ctrl + V). Qari qoraalka ee gacanta - (Alt + gala).

hawlgallada navigation

Si aad u qabtaan beddelaad bixisaa soo socda furayaasha kulul Excel. Wac window "Go» - (Ctrl + G). Jump: in ay gacanta midig - (Tab); in ay gacanta bidixda - (Shift + Tab); mid screen - (PageUp); hoos ka mid ah shaashadda - (PageDown); caleen soo socda - (Ctrl + PageDown); on sheet hore - (Ctrl + PageUp); degaanka xogta: ka cell hore - (Ctrl + Home); waayo, lifaqaya unug - (Ctrl + End); jihada fallaadhii in ay gacanta ugu horeysay - (Ctrl + Arrow). Si aad u kala warqadaha buugga furan - (Ctrl + F6).

formatting Text iyo cell

Si aad u qaab qoraalka ee gacanta (goobta) ee la doortay loo isticmaali Excel furayaasha kulul in ay yihiin hoos ku qoran. In isku kuwan isticmaalaan furaha Ctrl daray furayaasha kale lagu qeexay in hoosaadka this, in parentheses.

Font: geesi - (B), ee hoosta ka xariiqay - (U), dhuuban - (3), strikethrough - (5). Menu: isbedelka Font - (Shift + F), size font - (Shift + P). Codso xuduudaha sumadda - (wareeg + 7). Oo soohdimihiinna oo dhan saar - (wareeg + xariiqay).

Wac ilaa menu: formatting cell - (1), xulashada font - (Shift + F), dooro size font a - (Shift + P). format Set: danta - (Shift + 5), tiro ah - (wareeg + 1), waqtiga - (Alt + 2), taariikhda - (Alt + 3), lacagta caddaanka ah - (Alt + 4), is-dhaafsiga - (wareeg + 4) , caadi (inay ka soo saarto formatting) - (Shift + #).

Doorashada iyo tafatirka qoraalka

Highlight: sheet oo dhan - (Ctrl + A), line buuxa - (Shift + bannaan), column oo dhan - (Ctrl + Space), isugu soo cell ah jihada of fallaadho - (Shift + arrow) cell isugu diyaariyeen ka kooban caleen buugga xogta - (Ctrl + Shift + 8).

text iftiimiyay: cut (baseka) - (Ctrl + X), Copy (in sabuurad) - (Ctrl + C). Jinka - (Ctrl + V). Si aad u tirtirto hal qof ka dulqabo: Left (Tirtir), bidix ee - (Backspace). Beddelidda gacanta firfircoon - (F2). Delete qiimaha hadda jira iyo bedesho gacanta firfircoon - (bannaan).

furayaasha kale kulul Excel

Wac sanduuqa Search text - (Ctrl + F), bedelo qoraalka - (Ctrl + H), xulo qaab - (Alt + '). Si toos ah loo abuuro shaxda a on sheet cusub (F11). Beddel comment in ay gacanta - (Shift + F2). AutoSum Xisaabinta xulay unugyada khaanadda - (Alt + =); qiimaha wadarta waxaa la dhigay column ee gacanta oo isku xigta ku xiga hoos doorashada. Geli gacanta loo doortay hadda: Taariikhda - (Ctrl + wareejin +4), halka - (Ctrl + wareejin +6). Spellcheck - (F7).

Next, aan ka hadalno sida loo milmaan unugyada ee Excel. Hotkey, kiiskan, nasiib daro, ma caawiye ah. Si kastaba ha ahaatee, waxaa jira qaar ka mid ah tabaha kaa caawin kara in aad yareyso qaar ka mid ah dhibaatada.

geynta The

Haddii aad rabto in aad ku milmaan unugyada in Excel, waxaa jira dhibaatooyin qaar ka mid ah. Ka dib markii howlgalkan ku lug khasaaraha xogta ee unugyada oo dhan ayaa la isku daro aagga, marka laga reebo dhanka bidix ee sare. First aad leedahay in ay doortaan meesha unugyada in la isku daro, riix badhanka mouse xaq on goobta doorashada, dooro shayga "Unugyada Format ..." hoos-hoos menu. "Unugyada Format" window muuqataa keligeed, waxa ay doortaan in "Sinaanta" tab iyo sax "unugyada biirtay." Si ay u fuliyaan howlgal ee su'aasha guud ahaan ma bixiyo tuuryo keyboard Excel.

Milmaan unugyada fudud in la qabtaa la button gaar ah "ku milmaan & Center", oo ku yaalla menu "Home". Haddii aadan haysan in aad meel xogta ee xarunta, riix qoraalka si xaq ah badhanka, iyo in submenu hoos-hoos ah, dooro wax ku habboon. By habka, haddii inta badan aad isticmaasho howlgalkan, waxaa fiican inaad meel badhanka on Access Quick ka Toolbar. Si loo badbaadiyo xogta laga unugyada kale ee isku gobolka marka laga reebo dhanka bidix ee sare, aad leedahay si ay u gudbiyaan waxyaabaha ay u meel kale ama iyagoo aad ku dartid gacanta taasi oo ka koobiyeynta (ama goynta) iyo dhajinta.

Siyaabo kale oo ay suurtagal tahay in la isu geeyo unugyada, marka laga reebo khasaaraha ka mid ah macluumaadka la xiriira isticmaalka macros laga heli karo, tusaale ahaan, inay ka shaqeeyaan forums Excel. Mabda'a hawlgalka ee Dhaqale waa la mid ah sida gacanta, laakiin waa ka dhaqso iyo ka yar dareemi si user ah.

Sida aad u gashanayso isku xigta la hotkeys

Inta badan waxaa loo baahan yahay in warqadda Excel ah in aad is geliso isku xigta. furayaasha Hot loo isticmaalo hawlgalka this - Ctrl + daray calaamad. Waa in la muujiyo safka on taas oo ay lagama maarmaan tahay in aad is geliso mid cusub. xulashada Tani waxa lagu samayn karaa furayaasha kulul (Shift + Space) ama adigoo gujinaya badhanka mouse bidix ee tirada xigta baahisey bidixda, marka dulqabo ay isbedesho in qaab fallaadh. Haddii line a aan la soo xulay, hotkey ka (Ctrl + daray calaamad) keenaysaa in muuqaalka kore ee "Intaa waxaa dheer ee unugyada" ee menu u dhigma in siiyaa kala doorasho ah waxa la Cudarada: unugyada wareeg ama xaq, oo isku xigta ama column.

Excel hotkey "Delete line» - (Ctrl + calaamad laga jaray). Si aad u tirtirto xiriir ah waxaa lagama maarmaan ah in ay doortaan oo uu saxaafadda this isku darka muhiimka ah.

Marka aad riix furaha Alt on bar codsiga menu soo bandhigayaa tilmaamo furayaasha kulul u dhiganta alaabta menu. Tan waxaa lagu muujiyey in tirada. Available for versions of barnaamijka bilaabo Excel 2007.

Paste gaarka ah ee Excel

Inta badan waxaa lagama maarmaan ah in aad is geliso galay gacanta kaliya ee qiimaha, ama formula oo kaliya. Si arrintan loo sameeyo, waxaa jira fursad u Excel - dhaji Gaarka ah. Hotkeys for this - (Ctrl + Alt + V).

"Dhaji Gaarka ah" sanduuqa wada hadal uga furmay marka aad riixdid furaha kuwan. Waa la heli karaa haddii wax yar ka hor waxaas la sameeyey koobi ama jarida shay, ka kooban gacanta, qoraalka xaashida ama barnaamij kale. In uu furmo suuqa, dooro meesha aad: caanaha, qaabab qiimaha, note ama wax kale oo ka mid ah fursadaha soo jeediyay.

Sayidka, akhriska ka kooban article this, aad ka soo baratay, waa maxay xukunka kulul Excel iyo sida loo isticmaalo. Dabcan, article uusan ku tilmaami oo dhan isku jira. Waayo, waxbarasho dheeraad ah oo buuxda ee mawduuca waa inay ka faa'iidaystaan suugaanta gaar ah.