Markaad bilowdo inaad ku qorto qaaciidada Excel , waxay soo bandhigaysaa liis aad u weyn oo aad ka dooran karto wax kasta oo aad si toos ah u dhammaystiri karto qaacidada. Si kastaba ha noqotee, haddii aadan jeclayn inaad muujiso liiska qaacidooyinka markaad ku qorayso Excel^(Excel) , waad qarin kartaa.

Excel waa mid ka mid ah qalabka ugu wanaagsan ee loo isticmaali karo qof kasta. Laga bilaabo abuurista jaantuska Pie^{(creating a Pie chart)} ilaa xisaabinta xiisaha fudud^{(calculating simple interest)} . Sida isticmaalayaasha Excel ay inta badan u baahan yihiin inay ogaadaan qaaciidooyinka si ay u qabtaan shaqo gaar ah, qalabkani wuxuu muujinayaa liiska qaacidooyinka suurtagalka ah marka isticmaaluhu bilaabo wax ku qorida. Liisku wuxuu soo baxayaa markaad wax ku qorto qaacido. Tusaale ahaan, fiiri sawirka soo socda-

Sida qoraalku ku bilaabmayo =, Excel waxa uu bilaabaa in uu tuso qaababka qaab liis ah. Inta badan, way ku anfacaysaa maadaama ay u ogolaato dadka isticmaala inay si dhakhso ah u doortaan caanaha. Si kastaba ha noqotee, dadka qaar ayaa laga yaabaa inaysan jeclayn sida dadka kale. Haddii aad ka mid tahay iyaga, waad joojin kartaa shaqadan adiga oo la kaashanayo hagahan.

Sida loo qariyo liiska qaacidooyinka marka aad ku qorayso Excel^(Excel)

Si aad u muujiso ama aad u qariso liiska qaacidooyinka marka aad ku qorayso Excel , raac talaabooyinkan-

1. Ku fur Excel kumbuyuutarkaaga.
2. Guji faylka^(File) .
3. Tag Ikhtiyaarada^(Options) .
4. U beddel^(Formulas) tabka foomamka.
5. Ka saar calaamadda sanduuqa hubinta ee AutoComplete Formula^{(Formula AutoComplete)} .
6. Guji badhanka OK

Marka hore ka fur Excel -ka kumbuyuutarkaaga. Hadda, dhagsii ikhtiyaarka faylka^{(File )} kaas oo ka muuqda geeska bidix ee sare ee shaashaddaada. Bogga xiga, waxaad ku arki kartaa badhanka la yiraahdo Options . Waxaad u baahan tahay inaad gujiso

Sida caadiga ah, waxaad ku jirtaa tabka Guud^(General) , laakiin waxaad u baahan tahay inaad u beddesho tab Formulas . Intaa ka dib, waxaad arki kartaa sanduuqa calaamadaynta ee lagu magacaabo Formula AutoComplete oo ka muuqda qaybta la shaqaynta qaacidooyinka^{(Working with formulas)} . Waxaad u baahan tahay inaad calaamadda ka saartid sanduuqa hubinta ee u dhigma oo guji OK badhanka si aad u badbaadiso isbeddelka.

Marka aad dhammayso tillaabada u dambaysa, ma arki kartid liiska qaacidooyinka oo dhammaystiran marka aad ku qorayso xaashida xaashida ee Excel .

Macluumaadkaaga, waxaad tusi kartaa ama qarin kartaa liiskan otomaatiga ah oo dhammaystiran adiga oo la kaashanayo furaha furaha sidoo kale. Waxaad riixi kartaa Alt+Down arrow si aad shaqada u qabato.

Waa intaas! Rajo in ay ku caawin

How to show or hide List of Formulas while typing in Excel

When you start typing a formula in Excel, it displays a massive list from where you can choose anything and autocomplete the formula. However, if you do not like to show the formula list while typing in Excel, you can hide them.

Excel is one of the best tools that can be used by almost anybody. From creating a Pie chart to calculating simple interest. As Excel users often require to know formulas to perform a specific job, this tool shows a list of potential formula when the user starts typing. The list appears when you type something related to a formula. For example, check out the following image-

As the text starts with =, Excel starts showing the formulas in a list format. In most cases, it is handy as it allows users to choose a formula quickly. However, some folks might not like it like everyone else. If you are one of them, you can disable this functionality with the help of this guide.

How to hide a list of formulas while typing in Excel

To show or hide a list of formulas while typing in Excel, follow these steps-

1. Open Excel on your computer.
2. Click the File.
3. Go to Options.
4. Switch to the Formulas tab.
5. Remove the tick from the Formula AutoComplete checkbox.
6. Click the OK button.

Open the Excel on your computer first. Now, click the File option that is visible on the top-left corner of your screen. On the next page, you can see a button called Options. You need to click on it.

By default, you are in the General tab, but you need to switch to the Formulas tab. After that, you can see a checkbox named Formula AutoComplete that appears in the Working with formulas section. You need to remove the tick from the corresponding checkbox and click the OK button to save the change.

Once you are done with the last step, you can no longer see the autocomplete list of formulas while typing in an Excel spreadsheet.

For your information, you can show or hide this autocomplete list with the help of a keyboard shortcut as well. You can press the Alt+Down arrow to get the job done.

That’s all! Hope it helps.

Related posts

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo beddelo tiirarka safafka gudaha Excel oo wata foomamka

• Sida Loo Sameeyo Liiska Hoos-u-dhaca ee Excel

• Sida loo qariyo xaashiyaha, unugyada, tiirarka, iyo qaaciidooyinka gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?