Waxaan taageere weyn u ahay tignoolajiyada qoraalka-ku-hadalka, badiyaa sababtoo ah si fiican uma shaqeeyo. Si kastaba ha noqotee, mararka qaarkood waxay ku dhammaataa inay faa'iido u yeelato xaaladaha qaarkood.

Excel waxaa ka buuxa astaamo badan, oo ay ku jiraan mid la yiraahdo Speak Cells, kaas oo asal ahaan kuu ogolaanaya inaad ku quudiso unugyada aad dooratay mashiinka qoraalka-ku-hadalka. Waa qalab aad u wanaagsan oo la geli karo - marka ay indhahaygu aad u daalan yihiin inay akhriyaan unugyada shaashadda kombiyuutarkayga, waxaan u ogolaanayaa Excel inuu kor u akhriyo qiimaha aniga.

U oggolow Unugyada Hadalka ee Excel

Sida caadiga ah, si sahal ah loogama heli karo menu-ka Excel , sidaa darteed wax yar oo ka mid ah aaladaha Helitaanka Degdegga ah^{(Quick Access)} waa lagama maarmaan. Marka hore^(First) fur Toolbarka Helitaanka Degdegga ah^{(Quick Access Toolbar)} ka dib dooro Amarro Badan^{(More Commands)} :

Hoosta " Dooro amarrada^{(Choose commands from)} " hoos-u-dhaca dooro " Dhammaan amarrada^{(All Commands)} " ka dibna dooro amarrada unugyada Speak^{(Speak Cells)} .

Hubi^(Make) inaad doorato dhammaan amarrada Unugyada Speak^{(Speak Cells)} si loogu daro liiskaaga:

Guji OK^{(Click OK)} si aad u dabaqdo isbeddellada Waa inaad aragto badhamada ka muuqda liiska:

Si aad u isticmaasho amarrada, dooro unugyada aad rabto in lagu akhriyo ka dibna dhagsii badhanka Speak Cells .

Codka kumbuyuutarka ayaa ku hadli doona qiyamka unugyada aad dooratay. By default, waxay u akhrin doonaa iyaga by saf. Si aad u kala beddesho inta u dhaxaysa safafka ama ku hadalka tiirar, kaliya dhagsii badhamada u dhigma sida ka muuqata sawirka kore.

Labadan badhamada waxay u dhaqmaan sida beddelka. Mid keliya ayaa firfircoon, marka marka aad mid ka mid ah gujiso, ka kalena wuu dami doonaa. Sidoo kale, badhanka u dambeeya waa unugyada ku hadal^{(Speak cells on Enter)} ikhtiyaarka geli. Markaad gujiso batoonkan, waxay ku hadlaysaa unug kasta markaad riixdo furaha Gelida^(Enter) .

Guud ahaan, waxay qabataa shaqo aad u wanaagsan oo akhrinta qoraalka, gaar ahaan haddii aad isticmaalayso nooc cusub oo Windows iyo Office ah sida Windows 10 ama Office 2016 . Halkan waxaa ah muunad maqal ah oo Excel ah oo akhrinaya afarta saf ee xaashidayda Excel .

Tani waa mid ka mid ah sifooyinka ugu wanaagsan ee helitaanka Microsoft Excel . Habkani waxa uu iga caawiyaa in aan ansixiyo xogta xaaladaha marka aan aad u daalanahay in aan si sax ah u akhriyo qiyamka unugyo badan. Ku raaxayso!

How to Use Excel’s Speak Cells Feature

I am a big fan of text-to-speech technology, mostly because it doesn’t work all that well.  However, sometimes it ends up being usеful for certain sіtuations.

Excel is packed with many features, including one called Speak Cells, which basically lets you feed your chosen cells to a text-to-speech engine. It is a great accessibility tool – when my eyes are  too tired to read the cells on my computer screen, I just let Excel read aloud the values for me.

Enable Speak Cells in Excel

By default, it is not easily accessible in the Excel menu, so a little tweak in the Quick Access toolbar is necessary. First open the Quick Access Toolbar then choose More Commands:

Under the “Choose commands from” dropdown choose “All Commands” then choose the Speak Cells commands.

Make sure to choose all Speak Cells commands so they will be added in your menu:

Click OK to apply the changes.  You should see the buttons appear on the menu:

To use the commands, select the cells that you want to be read then click the Speak Cells button.

The computer voice will speak the values of the cells you selected. BY default, it will read them by rows. To switch between speak by rows or speak by columns, just click on their corresponding buttons as shown in the screenshot above.

These two buttons act like a switch. Only one is active, so when you click one of them, the other one gets deactivated. Also, the last button is the Speak cells on Enter option. When you click on this button, it will speak any cell when you press the Enter key.

Overall, it does a pretty good job of reading the text, especially if you are using a newer version of Windows and Office like Windows 10 or Office 2016. Here’s an audio sample of Excel reading the four rows in my Excel spreadsheet.

This is one of the best accessibility features of Microsoft Excel.  This feature helps me validate data in cases when I’m too tired to accurately read the values of many cells. Enjoy!

Related posts

• Sida loo isticmaalo Excel's What-If Analysis

• Adeegsiga Qalab Raadinta Hadafka ee Excel Maxaa-Haddii Falanqaynta

• 2 siyaabood oo loo Isticmaalo Shaqada Transpose ee Excel

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Sida loo Quful Unugyada Microsoft Excel

• Sida Loo Raadiyo Excel

• Sida loo raad raaco Ku-tiirsanaanta gudaha Excel

• Sida loo Isticmaalo Tixraacyada Absolute ee Excel

• Sida Loo Hagaajiyo Safka gudaha Excel

• Sida Looga Saaro Safka Kooban Ee Excel

• Si degdeg ah ugu qor nambarada Word iyo Excel

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Sida loo xisaabiyo Z-Score gudaha Excel

• Sida loo Furo Word iyo Excel si Badbaado ah

• 3 Siyood Oo Unugyada Excel Loogu Kala Qaybiyo

• 5 siyaabood oo loogu badalo qoraalka nambarada gudaha Excel

• Sida loo sameeyo shaxda Pie ee Excel

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• 4 siyaabood oo loo isticmaalo calaamadda jeeg ee Excel

• Sida loo isticmaalo Flash Fill ee Excel