Maalmahan dadku waxay si xawli ah ugu wareegayaan inay taabtaan is-dhexgalka, laakiin shaqooyinka qaarkood kiiboodhka ayaa gabi ahaanba lama huraan u ah. Haddii aad isticmaalayso Microsoft Excel si aad u samayso tiro culus oo jajaban, su'aal kama taagna in kiiboodhka wanaagsani aanu ahayn ikhtiyaar ikhtiyaari ah. 

Si kastaba ha ahaatee, ma aha oo kaliya qalabka ugu fiican ee gelitaanka xogta. Kiiboodhkaagu wuxuu dhab ahaantii kuu rogi karaa Master of Excel Kung Fu , taasoo kaa dhigaysa mid dhakhso badan oo hufan. Sidee? Adigoo isticmaalaya furayaasha kiiboodhka.

Faa'iidooyinka dhabta ah ee codsigu waxay had iyo jeer ahaayeen kuwa xafiday furayaasha furayaasha furaha ee muhiimka ah, si ay ugu shaqeeyaan codsigaas sida muusikiiste khibrad leh. Excel ma aha wax ka duwan oo marka aad ogaato hababka gaagaaban ee caadiga ah ee kiiskaaga isticmaalka caadiga ah, waxaad filan kartaa inaad si dhakhso ah wax u qabato. 

Hagaajinta dhererka safka iyo ballaca tiirka waa wax isticmaale kasta oo Excel ah ay tahay inuu sameeyo. Taas oo macnaheedu yahay haddii aad u socotid inaad hoos u bilowdo wadada dagaalyahanka keyboard-ka ee Excel^{(Excel keyboard)} , adoo isticmaalaya furaha gaaban ee dhererka safka ama ballaca tiirka ee Excel waa meesha ugu fiican ee lagu bilaabo.

Sixirka Furaha ALT^{(The Magic Of The ALT Key)}

Sababta ugu weyn ee isticmaalayaasha badankood aysan u dhibin barashada furayaasha kiiboodhka waa sababta oo ah dhaqan ahaan waa inaad ku barataa farabadan oo iyaga ka mid ah wadnaha. Taasi waxay u badan tahay sababta daawashada isticmaale-gaab gaaban ee kiiboodhka khibrada leh uu weerarayo xaashida xamaasadda leh wuxuu dareemi karaa sida Voodoo . 

Microsoft waxay dhibaatadan si buuxda uga saartay isla'egta hal badhan oo keliya - ALT .

Waxaan isticmaaleynaa Excel 365 oo sida aad arki karto, garaacista badhanka ALT waxay ka dhigaysaa qalab yar oo badan oo soo baxa. ^(ALT)Mid kasta oo kuwan ka mid ah wuxuu u taagan yahay xarafka xiga ee aad riixi karto si aad u gasho shaqada u dhiganta. Markaa maaha inaad ka walwasho inaad si fiican u xifdinayso jid-gaabyadan gabi ahaanba. Markaad dhawr jeer ku cel-celisto, soo-jeedimahan gaaban waxay had iyo jeer kaa caawin doonaan inay ku xasuusiyaan waxaad samayn lahayd. 

Waxa kaliya ee ay tahay inaad ogaato hadda waa in keyboard kasta oo gaaban ee Excel uu ku bilaabmayo taabasho fudud ee furaha ALT .

Balaadhka Tiirka Atootifit^{(Autofit Column Width)}

Habka caadiga ah ee si toos ah ugu habboon ballaca tiirka ee jiirka, waa in la laba jeer gujiyo xudduudaha madaxa tiirka, laakiin waxaad dhab ahaantii ku samayn kartaa adigoo isticmaalaya kiiboodhka, kaas oo guud ahaan degdeg ah. 

Sida cad, waxaad u baahan tahay in la doorto unugga aad rabto in aad si toos ah u hagaajiso ballaca tiirka. Markaad taas sameyso, halkan waa sida ugu dhakhsaha badan ee loo hagaajin karo ballaca tiirka. Dhibaatadu waxay tahay in qoraalka aad ugu badan yahay ballaca tiirka. Aan saxno taas!

• Marka hore, taabo ALT^{(press ALT )} si aad Excel ugu dhejiso habka gaaban. Kadibna ku dhufo furaha H^{(hit the H key )} si aad ugu wareegto tabka Guriga.

• Ugu dambeyntii, taabo O ka dibna I^{(press O and then I)} .

Aad^(Pretty) u fudud sax? Waxaan samayn karnaa wax la mid ah dhererka safka sidoo kale!

Dhererka Safka Toosan^{(Autofit Row Height)}

Habka si toos ah loogu hagaajiyo dhererka safka ee kiiboodhka waa isku mid. Dhab ahaantii, furaha gaaban ee kiiboodhka dhererka safka ee Excel wuxuu ku kala duwan yahay hal fure oo keliya.

• Marka hore, taabo ALT^{(press ALT )} si aad Excel ugu dhejiso habka gaaban. Kadibna ku dhufo furaha H^{(hit the H key )} si aad ugu wareegto tabka Guriga.

• Ugu dambeyntii, taabo O ka dibna A^{(press O and then A)} .

Tani waxay hagaajin doontaa dhererka safka si uu u dhigmo unugga ugu dheer ee safka. Shaqada waa^(Job) la qabtay!

Dhererka Safka Gacan-gaaban & Hagaajinta Balaadhka Tiirka^{(Manual Row Height & Column Width Adjustment Shortcuts)}

Iyadoo gaagaabyada hagaajinta unugyada otomaatiga ah ay faa'iido u leedahay, mararka qaarkood waxaad u baahan doontaa inaad hagaajiso cabbirada saxda ah ee unugyada xaashidaada. 

Sida aad filan karto, waxaad isticmaali kartaa furayaasha kiiboodhka si aad u gasho jaangooyooyinka soo bandhigaya lambarada su'aasha ah.

• Si aad gacanta ugu hagaajisid dhererka safafka, taabo ALT^{(press ALT )} si aad Excel ugu dhejiso habka gaaban. Kadibna ku dhufo furaha O^{(hit the O key )} si aad u gasho ikhtiyaarada menu-ka dhaxalka ah ee Excel 365 .

• Hadda, riix R ka dibna E^{(press R and then E)} .
• Waxaad arki doontaa sanduuqan wada-hadalka oo ka soo baxaya qiimaha joogga hadda. U beddel wax kasta oo aad jeceshahay oo ku dhufo Geli^{(hit Enter)} si aad ugu xidho.

• Si aad gacanta ugu hagaajiso ballaca tiirka, taabo ALT^{(press ALT )} si aad Excel ugu dhejiso habka gaaban. Kadibna ku dhufo furaha O^{(hit the O key )} si aad u gasho ikhtiyaarada menu-ka dhaxalka ah ee Excel 365 .

• Hadda, riix C ka dibna W^{(press C and then W)} .

• Mar labaad, waxaad heli doontaa daaqadan yar oo kuu ogolaanaysa inaad geliso ballaca tiirka saxda ah ee aad rabto. Dooro lambar kasta oo ku dareensiiya diirimaad iyo wareer.

Waa kaas! Hadda waxaad tahay sayid dhab ah oo dhererka iyo ballaca unugyadaada ah. Adigoon u baahnayn jiir, oo aan wax kale ku hubaysanayn oo aan ahayn kiiboodhka ayaa hubkaaga ah.

Qoriga ugu dhaqsaha badan ee Excel ee Galbeedka^{(The Fastest Excel Gun In The West)}

Kadib markaad isku daydo furayaashan kiiboodhka laftaadu, waxay u badan tahay inaad ogolan doonto in isticmaalka jiirka uu yahay jiid dhab ah iyo mid sawireed labadaba. Hubaal, waxay u muuqataa^{(seems )} mid sahlan, laakiin xasuus yar oo muruqa ah waxaad ku hagaajin kartaa dhererkaaga safka iyo ballaadhka tiirka si aad u hesho shuruudahaaga saxda ah isla markiiba. Markaad marto dariiqa kiiboodhka, way adagtahay inaad dib u noqoto.

Hubi inaad hubiso casharradayada kale ee Excel^{(Excel tutorials)} si aad wax uga barato fur-gaabyada kale ee kiiboodhka ee faa'iidada leh iyo tabaha iyo tabaha Excel^{(Excel tips and tricks)} cajiibka ah oo aadan garan doonin sidaad la'aantood u noolayd.

Use the Keyboard to Change Row Height and Column Width in Excel

Τhese daуs people are moving over to touch intеrfaces at a rapid paсe, but for certain types of work a keyboard is absolutely essential. If you are using Microsoft Excel to do some heavy number crunching, there’s no question that a good keyboard is not an optionаl extra. 

However, it’s not just the perfect device for data entry. Your keyboard can actually turn you into a master of Excel Kung Fu, making you faster and more efficient. How? By using keyboard shortcuts.

The real pros for an application have always been those who have memorized the most important keyboard shortcuts, so they can work that application like a seasoned musician. Excel is no different and once you know the most common shortcuts for your typical use case, you can expect to get things done much more quickly. 

Adjusting row height and column width is something every Excel user has to do. Which means if you’re going to start down the road of Excel keyboard warrior, using a keyboard shortcut for row height or column width in Excel is the perfect place to start.

The Magic Of The ALT Key

The main reason most users don’t bother learning keyboard shortcuts is because traditionally you have to learn a whole bunch of them by heart. That’s probably why watching an experienced keyboard shortcut user attack a spreadsheet with gusto can feel like Voodoo. 

Microsoft have taken this problem completely out of the equation with just one little button – ALT.

We’re using Excel 365 and as you can see, hitting the ALT button makes numerous little tooltips pop up. Each of these represents the next letter you can press to access the corresponding function. So you don’t have to worry about perfectly memorizing these shortcuts at all. Once you’ve practiced them a few times, these shortcut prompts will always help remind you of what to do next. 

All you have to know right now is that every keyboard shortcut for Excel starts with a simple tap of the ALT key.

Autofit Column Width

The classic way to automatically fit column width with the mouse, is to double-click the column header border, but you can actually do it using the keyboard, which is generally faster. 

Obviously, you need to have the cell selected for which you want to automatically adjust the column width. Once you’ve done that, here’s the fastest way to adjust the column width. The problem is there is too much text for the column width. Let’s fix that!

• First, press ALT to put Excel into shortcut mode. Then hit the H key to switch to the Home tab.

• Finally, press O and then I.

Pretty easy right? We can do something similar for row height as well!

Autofit Row Height

The method to automatically adjust row height with the keyboard is practically identical. In fact, the keyboard shortcut for row height in Excel differs by just a single keystroke.

• First, press ALT to put Excel into shortcut mode. Then hit the H key to switch to the Home tab.

• Finally, press O and then A.

This will adjust the row height to match the tallest cell in the row. Job done!

Manual Row Height & Column Width Adjustment Shortcuts

While the shortcuts for automatic cell adjustment is incredibly useful, sometimes you’ll want to fine-tune the exact dimensions of the cells in your spreadsheet. 

As you might expect, you can use keyboard shortcuts to access the settings that expose the numbers in question.

• To manually adjust row height, press ALT to put Excel into shortcut mode. Then hit the O key to access Excel 365’s legacy menu options.

• Now, press R and then E.
• You’ll see this dialogue box pop up with the current height value. Change it to whatever you like and hit Enter to lock it in.

• To manually adjust column width, press ALT to put Excel into shortcut mode. Then hit the O key to access Excel 365’s legacy menu options.

• Now, press C and then W.

• Again, you’ll get this little window that lets you put in the exact column width you desire. Choose whichever number makes you feel warm and fuzzy inside.

That’s it! Now you are a true master of the height and width of your cells. Without the need for a mouse, armed with nothing but a keyboard as your weapon.

The Fastest Excel Gun In The West

After trying out these keyboard shortcuts yourself, you’ll probably agree that using the mouse is both a literal and figurative drag. Sure, it seems easier, but with a little muscle memory you can tweak your row heights and column widths to your exact requirements at a moment’s notice. Once you walk the keyboard path, it’s hard to ever turn back.

Be sure to check our other Excel tutorials to learn about other useful keyboard shortcuts and amazing Excel tips and tricks you won’t know how you lived without.

Related posts

• Sida loo beddelo Dhererka Safka iyo Balaadhka Tiirka gudaha Excel

• Sida Loo Hagaajiyo Safka gudaha Excel

• Balacaha Saarka AutoFit iyo Dhismayaasha Saf ee Excel

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• 5 siyaabood oo loogu badalo qoraalka nambarada gudaha Excel

• Sida Taariikh ahaan loogu kala saaro Excel

• Sida loo isticmaalo Excel's What-If Analysis

• Si degdeg ah ugu qor nambarada Word iyo Excel

• Sida loo isticmaalo Flash Fill ee Excel

• Ilaali Tixraaca Unugyada marka aad nuqul ka samaynayso foomamka gudaha Excel

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• Adeegsiga Qalab Raadinta Hadafka ee Excel Maxaa-Haddii Falanqaynta

• Sida loo Isticmaalo Tixraacyada Absolute ee Excel

• Sida Dhakhso Loo Geliyo Safaf Badan gudaha Excel

• Sida loo raad raaco Ku-tiirsanaanta gudaha Excel

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Sida loo sameeyo shaxda Pie ee Excel

• U samee ama u abuur furaha-gaaban ee kiiboodhka ee Microsoft Office

• Sida Loo Geliyo CSV ama TSV Xaashida Shaqada ee Excel