Hababka gaagaaban^{(Keyboard shortcuts)} ee kiiboodhka ee Excel waxaa loogu talagalay inay noloshaada ka dhigaan mid sahlan. Waxay soo gaabiyaan wakhtiga loo baahan yahay si ay u qabtaan hawlaha qaarkood, falalka, iyo amarada. Haddii aad leedahay Mac oo aad u isticmaasho Microsoft Excel nolol maalmeedkaaga, jidadka gaaban ee ku jira boostadan ayaa hagaajin kara wax soo saarkaaga.

Waxaan iftiiminaynaa qaar ka mid ah hababka gaagaaban ee Excel ugu fiican ee ^(Excel)Mac -gaaga qaabaynta xogta, tafatirka gelida xogta, dhex galka waraaqaha shaqada, maaraynta faylalka, iwm. Waxa kale oo aad heli doontaa gaagaabyada caanka ah ee ay inta badan isticmaalaan isticmaalayaasha Excel .

Sida cherry-ka sare, waxaan sidoo kale ku darnay tillaabooyin si aad u abuurto fur-gaabyada kiiboodhka gaarka ah ee Excel .

Jid-gaabyada Hagidda

Ku-wareejinta xaashidaada shaqo ama buug-shaqeedka Excel mararka qaarkood way adkaan kartaa, gaar ahaan haddii aad ku shaqaynayso xog-ururin weyn. Jidadka gaagaaban ayaa ka dhigi kara hagidda si fudud oo degdeg ah.

1. U bood Bilawga Xaashida^{(1. Jump to the Beginning of a Sheet)}

Waxaad u rogtey dhamaadka xaashida shaqada ee Excel laakiin ma rabtaa inaad si degdeg ah u booddo barta bilawga ah? Riixitaanka Control + Fn + Furaha fallaadha bidix^{(Left arrow key)} waxay ku geyn doontaa safka ugu horreeya ee xaashida.

2. U gudub Bilawga Safka^{(2. Jump to the Beginning of a Row)}

Kani waxa uu la mid yahay jeex-jeexa sare, laakiin kani waxa uu dib kuugu celinayaa unugga kowaad ee isku xigta. Waxaad dhahdaa^(Say) waxaad u rogtey unuga 400aad ee isku xigta, taabo Fn + fallaadha bidix^{(Left arrow key)} si aad dib ugu noqoto unuga kowaad ee safkaas.

3. Jump to the Beginning of a Column/Line

Riix Command ( Cmd ) + Furaha fallaadha^{(Arrow Up)} si aad u aado unugga ugu horreeya ee safka xogta isku xigta ee Excel .

4. Bedel warqadaha shaqada^{(4. Switch Worksheets)}

Excel waxa uu leeyahay habab-gaaban oo si fudud loogu dhex maro xaashiyo badan oo ku jira buugga shaqada^{(navigating multiple sheets in a workbook)} . Taabo ikhtiyaarka^(Option) + fallaadha midigta^{(Right arrow key)} si aad ugu guurto xaashida shaqada ee xigta (dhanka midig) ee buuggaaga shaqada ee Excel . Si aad ugu guurto xaashi hore oo shaqo (bidix), taabo Option + fallaadha bidixda^{(Left arrow key)} .

Habaynta iyo Tafatirka Xogta

Jidadka gaaban ee kiiboodhkan waxay kobcin doonaan gelida xogta degdega ah iyo habaynta xogta xaashidaada Excel . 

5. Kordhi cabbirka farta^{(5. Increase Font Size)}

Ma u xoojisaa indhahaaga si aad macno u samayso qoraallada iyo tirooyinka xaashidaada Excel ? Dhab ahaantii waa inaad kordhisaa cabbirada farta ee dhammaan safafka iyo tiirarka.

Dooro dhammaan xaashida shaqada ( Command + A ) oo tabo Shift^(Shift) + Command + > ( furaha garabka midig^(Right) ) si aad u kordhiso cabbirka qoraalka warqadda shaqada.

Waxa kale oo aad kordhin kartaa cabbirka farta unug gaar ah, saf, ama tiir. Kaliya^(Simply) dooro unugga, safka, ama tiirka oo tabo Shift^(Shift) + Command + > .

6. Yaree cabbirka farta^{(6. Decrease Font Size)}

Tani waxay la mid tahay sida ay u fududahay kordhinta cabbirada farta. Dooro unugyada, safafka, ama tiirarka cabbirkooda farta aad rabto inaad yarayso oo tabo Shift^(Shift) + Command + < (furaha garabka bidix).

7. Si geesinnimo leh, farta ugu dheji oo hoosta ka xarriiq qoraalka^{(7. Bold, Italicize and Underline Text)}

Kuwan waxaa caadi ahaan loo adeegsadaa sifada qaabaynta qoraalka ee Excel iyo aaladaha kale ee Microsoft .

Dooro unugyada aad rabto inaad wax ka beddesho oo taabo Command + B si aad u isticmaasho qaabaynta geesinimada leh. Command + I iyo Command + U waxay adeegsan doonaan qaabaynta "italic" iyo "xariiqda hoose" ee tiirka, safafka, ama unugyada la doortay.

Waxa kale oo aad isticmaali kartaa kuwan gaaban si aad u tirtirto ama uga saarto qaabka aad u codsatay unugga.

8. Fur sanduuqa wada hadalka Unugyada Qaabka^{(8. Open Format Cells Dialog Box)}

Sanduuqa wada-hadalka ee Unugyada Qaabka^{(Format Cells)} , waxaad heli kartaa ikhtiyaarada qaabaynta ballaaran ee nambarada, toosinta, xarfaha, iwm. Waxaad dhahdaa^(Say) inaad rabto inaad bedesho qaabka taariikhda Excel ama qaabka lacagta, waxaad ku sameyneysaa sanduuqa wada hadalka Unugyada Qaabka^{(Format Cells)} .

Riix Command + 1 si aad u furto sanduuqa wada hadalka.

9. Qari ama ka saar tiirka^{(9. Hide or Unhide a Column)}

Dooro^(Select) unug kasta oo ku jira tiirka aad rabto inaad qariso oo tabo Command + )

Taasi waxay qarin doontaa dhammaan unugyada tiirka. Hubi inaad u fiirsato warqadda lagu qoray tiirka aad rabto inaad qariso. Taasi waxay kaa caawin doontaa inaad si fudud u heshid booska tiirka markaad rabto inaad qariso.

Waxaad qarin kartaa tiirar badan isku mar. Kaliya^(Simply) ka dooro unug ku jira tiir kasta oo isticmaal marinka kore si aad u qariso.

Si aad u qariso ama u muujiso tiir, dooro unug kasta oo bidix iyo midig kaga yaal tiirarka qarsoon oo tabo Shift^(Shift) + Command + ) .

10. Qari ama qari safka^{(10. Hide or Unhide a Row)}

Dooro^(Select) unug kasta oo safka aad rabto inaad qariso oo⁽⁽⁾ tabo Command +

Waxa kale oo suurtogal ah in isku mar lagu qariyo safaf badan xaashida shaqada^{(multiple rows in your worksheet)} .   

Si aad saf ugu soo celiso xaashidaada shaqo, dooro unugyada dhanka midig iyo bidix ee safka qarsoon oo tabo Shift^(Shift) + Command + ( .

11. Tafatir unug^{(11. Edit a Cell)}

Wali ma laba-gujisay unugyada Excel si aad u saxdo nuxurkooda? Riixitaanka F2 ama isticmaalka Control + U hotkey ayaa ah beddelka degdega ah. Jidadka-gaabni waxay dhaqaajiyaan “habka wax ka beddelka” oo dhig barta gelinta/cursorka dhammaadka khadka si aad isla markiiba u bilaabi karto tafatirka.

12. Geli Hyperlink^{(12. Insert a Hyperlink)}

Riix Command + K si aad u geliso xiriirinta qoraal. Control + K waa kiiboodhka beddelka ah ee gaaban kaas oo fuliya isla shaqo isku mid ah.

13. Bilow khad cusub^{(13. Start a New Line)}

Riix Return/Enter marka aad wax ku qorayso unug waxay dhamaystiri doonta gelitaanka unugga. Si aad u bilawdo khad cusub marka aad xogta unug gelayso, hayso furaha doorashada oo tabo ^(Option)Soo noqo^(Return) .

Waxa kale oo aad isticmaali kartaa Control + Option + Soo noqoshada^(Return) si aad u gaadho natiijo la mid ah.

Hab-gaabyada Excel ee inta badan la isticmaalo

Qaar ka mid ah furayaasha furaha ee qaybtan waa furayaasha kiiboodhka ee nidaamka fidsan^{(system-wide keyboard shortcuts)} ee ka shaqeeya abka kasta ee Mac kaaga . Waxay u badan tahay inaad horeba u isticmaashey maalin kasta, waxayna hubaan inay kaa caawinayaan inaad si dhakhso leh wax u qabato. Taasi waxay sharraxaysaa sababta ay liiskan ugu jiraan inay yihiin qaar ka mid ah furayaasha kiiboodhka Excel ugu fiican.^(Excel)

14. Ka noqo Isbadalada^{(14. Undo Changes)}

Ma^(Did) galisay xog aan sax ahayn ama khaldan xaashidaada shaqo? Mise, waxaad si fudud u rabtaa inaad ka noqoto fal dhawaan la fuliyay? Whack Command + Z ama Ctrl + Z kumbuyuutarkaaga Mac si aad uga noqoto falkii ugu dambeeyay ee lagu dabaqay xaashida shaqada.

15. Dib u habaynta Isbadalada^{(15. Redo Changes)}

Si aad dib ugu codsato falkii ugu dambeeyay ama qaacidada aad ku furatay Excel , taabo Command + Y ama Ctrl + Y. Taasi waxay "dib u samayn doontaa" fal dhawaan dib loo rogay.

Ka fakar "Control + Z" sidii aad qashinka uga soo saari lahayd (waraaqaha shaqada) iyo Control + Y sida aad dib ugu soo celinayso.

16. Ku dhaji Walxaha Gaarka ah^{(16. Paste Special Elements)}

Sifada "Paste Special" waxay ku timaadaa anfaca xaaladaha aan ku haboonayn habka caadiga ah ee koolada-koollada.

Haddii aad inta badan ku dhejiso walxo gaar ah buugaaga shaqada, isticmaal Control + Command + V shortcut si aad si dhakhso ah u gasho sanduuqa wada hadalka ee paste Special^{(Paste Special)} . Haddii kale, taabo Control + Option + V ama Command + Option + V .

17. Dooro safka oo dhan ama safka oo dhan^{(17. Select Entire Column or Entire Row)}

Isticmaal Control + Spacebar si aad u dooratid dhammaan unugyada tiirka ama Shift + Spacebar si aad u doorato dhammaan unugyada isku xigta ee xaashida shaqada.

18. Samee Buug Shaqo oo Cusub^{(18. Create a New Workbook)}

Ma doonaysaa inaad abuurto buug shaqo oo cusub marka aad Excel furayso ama markaad ka shaqaynayso buug kale oo shaqo? Riix Command + N ama Control + N kumbuyuutarkaaga si aad u sameyso.

Taasi waxay isla markiiba furi doontaa daaqad cusub oo Excel ah oo leh xaashi shaqo oo banaan. Aad ayey uga dhakhso badan tahay xulashada Excel > File > Ku cusub^(New) bar menu-kaaga Mac.

Samee fur-gaabyada kiiboodhka gaarka^{(Create Custom Keyboard Shortcuts)} ah gudaha Excel

Microsoft waxay u ogolaataa isticmaalayaasha inay abuuraan jid-gaabyada kiiboodhka gaarka ah^{(create custom keyboard shortcuts)} ee ku habboon shuruudaha isticmaalkooda. Haddaba, haddii aadan helin jid gaaban oo daboolaya baahiyahaaga, raac tillaabooyinka hoose si aad mid u abuurto.

1. Fur Excel, ka dooro Tools on the menu bar, oo dooro Customize Keyboard.

1. Gudbi^(Scroll) liiska "Qaybaha" oo dooro hoyga tabka amarka aad rabto inaad ku qorto jid gaaban. Ka dib^(Afterward) , dooro amar ku jira liiska "Commands" si aad u sii wadato.

Waxaad dhahdaa^(Say) inaad rabto inaad u qoondayso qaacidada Autosum jid-gaaban cusub, dooro Formulas Tab ee qaybta “Qaybta”, oo dooro Isugeyn toos ah^(Auto-sum) liiska “Commands”. Haddii amarku uu hore u lahaa jid-gaaban, waxaad arki doontaa furayaasha kulul ee sanduuqa “furayaasha hadda”. Haddii kale, sanduuqu wuu madhanaan doonaa.

1. Dooro sanduuqa wada hadalka gaaban ee kiiboodhka cusub^{(Press new keyboard shortcut)} oo hay furayaasha aad rabto inaad ku meelayso amarka la doortay.

Jidka gaaban waa in uu ka kooban yahay ugu yaraan hal fure wax ka beddel ( Command , Shift , Option , or Control ) iyo fure kasta oo kale ( xarfaha, furayaasha shaqada, nambarada, furayaasha jihada / fallaadho, iwm.).

1. Calaamadee natiijada "Hadda loo qoondeeyey" sanduuqa wada hadalka ka hooseeya oo hubi inay akhrido Aan La- meelayn^(Unassigned) . Haddii isku dhafka muhiimka ah mar hore loo qoondeeyey amar, qalabka wax lagu beddelo ayaa ku tusi doona ficilka hadda loo isticmaalo hotkey.

1. Dooro Ku dar^(Add) oo dooro OK si aad u meelayso furayaasha gaaban ee falka.

Isticmaalka gaaban ee kiiboodhka si aad u fiican

Suurtagal ma aha inaad xifdisan karto jidadka gaaban markaad tagto. Waxay qaadan kartaa maalmo ama toddobaadyo si aad u hesho ilaaliye fur-gaabyada kiiboodhkan, iyadoo ku xidhan inta jeer ee aad isticmaasho. Waxaan kugula talineynaa in maqaalkan lagu calaamadeeyo biraawsarkaaga si aad had iyo jeer ugu soo noqoto tixraaca jidadka gaaban.

Taasi waxay tidhi, Excel waxay leedahay boqolaal kiiboodhka gaaban. Haddii aadan u helin furayaashan mid faa'iido leh, waa inaad kala soo baxdid xaashida qiyamka gaaban ee Excel Shortcuts^{(download the Excel Shortcuts Cheat Sheet)} ee bogga Microsoft. Waa dukumeenti PDF ah oo ka kooban dhammaan kiiboodhka Excel^{(Excel keyboard)} ee kombiyuutarada Mac iyo Windows . U dhex mara dukumeentiga ku jira Horu-ujeedka ama wax kasta oo PDF^{(Preview or any PDF viewer)} ah oo samee raadinta si aad u hesho furaha furaha si aad ufuliso ficil ama qaacido gudaha Excel .

The 18 Best Excel Shortcuts for Mac Users

Keyboard shortcuts in Excel are designed to make your life easy. They shorten the time required to perform certain tasks, actions, and commands. If you own a Mac and you use Microsoft Excel in your everyday life, the shortcuts in this post can improve your productivity.

We highlight some of the best Excel shortcuts on your Mac for formatting data, editing data entry, navigating worksheets, managing files, etc. You’ll also find popular shortcuts frequently used by many Excel users.

As a cherry on top, we also included steps to create your own custom keyboard shortcuts in Excel.

Navigation Shortcuts

Moving around your worksheet or workbook in Excel can sometimes be difficult, especially if you’re working with a huge dataset. These shortcuts can make navigation easier and faster.

1. Jump to the Beginning of a Sheet

You’ve scrolled to the end of an Excel worksheet but want to quickly jump to the starting point? Pressing Control + Fn + Left arrow key will take you to the first row/column in the sheet.

2. Jump to the Beginning of a Row

This is similar to the shortcut above, but this one takes you back to the first cell in a row. Say you’ve scrolled all the way to the 400th cell in a row, press Fn + Left arrow key to go back to the first cell in that row.

3. Jump to the Beginning of a Column/Line

Press Command (Cmd) + Arrow Up key to go to the first cell in a column of contiguous data in Excel.

4. Switch Worksheets

Excel has shortcuts for easily navigating multiple sheets in a workbook. Press Option + Right arrow key to move to the next worksheet (to the right) in your Excel workbook. To move to a previous worksheet (to the left), press Option + Left arrow key.

Formatting and Editing Data

These keyboard shortcuts will foster quicker data entry and data arrangement in your Excel worksheet. 

5. Increase Font Size

Do you squint your eyes to make sense of texts and digits in your Excel worksheet? You should definitely increase the font sizes of all rows and columns.

Select the entire worksheet (Command + A) and press Shift + Command + > (the Right angle bracket key) to increase the worksheet’s font size.

You can also increase the font size of a specific cell, row, or column. Simply select the cell, row, or column and press Shift + Command + >.

6. Decrease Font Size

This is equally as easy as increasing font sizes. Select the cells, rows, or column whose font sizes you want to reduce and press Shift + Command + < (the Left angle bracket key).

7. Bold, Italicize and Underline Text

These are commonly used text formatting attributes in Excel and other Microsoft tools.

Select the cell(s) you want to modify and press Command + B to apply the bold formatting. Command + I and Command + U will apply the “italic” and “underline” formatting to the selected column, rows, or cells.

You can also use these shortcuts to undo or remove the respective formatting you applied to a cell.

8. Open Format Cells Dialog Box

In the Format Cells dialog box, you get access to extensive formatting options for numbers, alignment, fonts, etc. Say you want to change Excel’s date format or currency format, you do so in the Format Cells dialog box.

Press Command + 1 to open the dialog box.

9. Hide or Unhide a Column

Select any cell in the column you want to hide and press Command + ) (the Right parenthesis key).

That’ll conceal all cells in the column. Make sure you take note of the letter assigned to the column you want to hide. That’ll help you easily locate the position of the column when you want to unhide it.

You can hide multiple columns at the same time. Simply select a cell in each column and use the shortcut above to hide them.

To unhide or reveal a column, select any cell to the left and right of the hidden column(s) and press Shift + Command + ).

10. Hide or Unhide a Row

Select any cell(s) in the row you want to hide and press Command + ( (the Left parenthesis key).

It’s also possible to hide multiple rows in your worksheet simultaneously.   

To bring back a row to your worksheet, select cells to the right and left position of the hidden row and press Shift + Command + (.

11. Edit a Cell

Do you still double-click cells in Excel to edit their content? Pressing F2 or using the Control + U hotkey are faster alternatives. These shortcuts activate “edit mode” and position the insertion point/cursor at the end of the line so you can start editing instantly.

12. Insert a Hyperlink

Press Command + K to insert a link to a text. Control + K is an alternate keyboard shortcut that performs the same function.

13. Start a New Line

Pressing Return/Enter while typing in a cell will complete the cell entry. To start a new line when entering data in a cell, hold the Option key and press Return.

You can also use Control + Option + Return to achieve the same result.

Frequently Used Excel Shortcuts

Some hotkeys in this section are system-wide keyboard shortcuts that work in every app on your Mac. You probably already use them every day, and they sure help you get things done faster. That explains why they’re on this list as some of the best Excel keyboard shortcuts.

14. Undo Changes

Did you enter invalid or incorrect data in your worksheet? Or, you simply want to reverse a recently-executed action? Whack Command + Z or Ctrl + Z on your Mac’s keyboard to undo the most recent action applied to the worksheet.

15. Redo Changes

To reapply the last action or formula you undid in Excel, press Command + Y or Ctrl + Y. That will “redo” a recently-reversed action.

Think of “Control + Z” as taking the trash out (of your worksheet) and Control + Y as bringing it back in.

16. Paste Special Elements

The “Paste Special” feature comes in handy in situations where the standard canopy-paste functionality isn’t appropriate.

If you often paste special elements in your workbook, use the Control + Command + V shortcut to quickly access the Paste Special dialog box. Alternatively, press Control + Option + V or Command + Option + V.

17. Select Entire Column or Entire Row

Use Control + Spacebar to select all cells in a column or Shift + Spacebar to select all the cells in a row on your worksheet.

18. Create a New Workbook

Want to create a new workbook when you open Excel or while working on another workbook? Press Command + N or Control + N on your keyboard to get it done.

That’ll immediately open a new Excel window with a blank worksheet. It’s a lot faster than selecting Excel > File > New on your Mac’s menu bar.

Create Custom Keyboard Shortcuts in Excel

Microsoft lets users create custom keyboard shortcuts tailored to their usage requirements. So, if you don’t find a shortcut that meets your needs, follow the steps below to create one.

1. Open Excel, select Tools on the menu bar, and select Customize Keyboard.

1. Scroll through the “Categories” list and select the tab housing the command you want to assign a shortcut. Afterward, select a command in the “Commands” list to proceed.

Say you want to assign the Autosum formula a new shortcut, select Formulas Tab in the “Categories” section, and select Auto-sum in the “Commands” list. If the command already has a shortcut, you’ll see the hotkeys in the “Current keys” box. Otherwise, the box will be blank.

1. Select the Press new keyboard shortcut dialog box and hold the keys you want to assign to the selected command.

The shortcut must contain at least one modifier key (Command, Shift, Option, or Control) and any other key (letters, function keys, numbers, directional keys/arrows, etc.).

1. Check the “Currently assigned to” result below the dialog box and make sure it reads Unassigned. If the key combination is already assigned to a command, the customization tools show you what action currently uses the hotkey.

1. Select Add and select OK to assign the shortcut keys to the action.

Use Keyboard Shortcuts Excel-lently

You can’t possibly memorize these shortcuts at a go. It may take days or weeks to get conservant with these keyboard shortcuts, depending on how often you use them. We recommend bookmarking this article in your browser so you can always come back to reference these shortcuts.

That said, Excel has hundreds of keyboard shortcuts. If you don’t find these hotkeys beneficial, you should download the Excel Shortcuts Cheat Sheet from Microsoft’s website. It’s a PDF document that contains all Excel keyboard shortcuts for Mac and Windows computers. Go through the document in Preview or any PDF viewer and perform a search to find the hotkey to execute an action or formula in Excel.

Related posts

• 5 Qalabka ugu Wanaagsan ee lagu Xakamaynayo Taageerayaasha Mac kaaga

• Furaha Keyboard-ka Mac OS X ugu Fiican

• Jid-gaabyada Keyboard-ka Mac ee ugu Wanaagsan ee Waxbarasho

• 40 ka ugu wanaagsan ee Keyboard-ka Microsoft Excel

• Sida loo beddelo luqadda Firefox ee Windows iyo Mac

• Sida loo sameeyo wicitaanada kooxda maqalka iyo muuqaalka ah ee Skype (Windows, Android, iPhone, Mac)

• Sida loo beddelo luqadda gelinta kiiboodhka ee Mac kaaga

• Sida loo rakibo Windows 8 ee Mac ku shaqeeya OS X Mountain Lion

• Sida loo beddelo Kooxda Shaqada ee Mac, 4 tillaabo

• 3 siyaabood oo loogu xidhi karo Wi-Fi on Mac ah

• Mac kuma xidhi doono Wi-Fi? Talooyin xallinta dhibaatada si aad Online ugu soo noqoto

• Sida loogu daabaco daabacaha Mac OS X la wadaago ee ka socda Windows 7 & Windows 8

• Xarunta Ogeysiinta ee Mac: Sida loo beddelo oo loo isticmaalo

• Sida loogu daro Printer on Mac ah

• Sida loo galo Windows 7 & Windows 8 Folders-ka la wadaago ee Mac OS X

• Sida loo Ilaaliyo Mac-gaga Xataa Iyadoo Daboolka uu Xidhan yahay

• Sida loo hagaajiyo Cusbooneysiinta Software-ka Mac rakibida

• Aaway astaanta Wi-Fi ee Mac? Sida loo awoodsiiyo ama loo qariyo

• Sida loo tirtiro fariimaha Skype (Windows, Android, iPhone, Mac)

• Sida midig-guji Mac-ga