Mid ka mid ah nimcooyinka ku jira la shaqaynta xaashida xaashida ee Microsoft Excel waa awoodda dib loo isticmaalo hababka iyo ku dabaqida xaaladaha cusub. Xaaladahaas, waxaad dooneysaa inaad hubiso inaadan si qalad ah u koobiyn mid ka mid ah qiyamkii hore ee gelitaanka kaasoo xumeyn kara natiijada. Markaad ka hesho xaashida faafinta ee qof kale ama xitaa markaad ka shaqeyso mid ka mid ah kaaga oo ka kooban wax yar oo kakanaanta ah, waxaad dooneysaa inaad si dhakhso ah u go'doomiso oo aad tirtirto dhammaan qiyamka wax gelinta ee quudiya hababka aad isticmaasho. Halkii laga xaqiijin lahaa unugga xaashida xaashida unug, samaynta shaqo dhib badan, waxaa jira hab si degdeg ah looga tirtiro dhammaan qiyamka xaashida xaashida ee Excel oo lagu hayo kaliya qaababka. Aan aragno sida tani u shaqeyso:

FIIRO GAAR AH^(NOTE) : Casharkaan waxa uu quseeyaa noocyada desktop-ka ee Microsoft Excel , ee laga helo Microsoft Office , iyo Office 365 . Ma khusayso noocyada mobilada ee Excel , sida kuwa bilaashka lagu helo, Windows 10 tablets, ama aaladaha leh Android iyo iOS.

Sida loo tirtiro qiyamka unugyada laakiin ku hay qaababkaaga Microsoft Excel

Waxaan u isticmaalnaa tusaale ahaan jadwalka deyn bixinta ee ay bixiso Microsoft iyada oo qayb ka ah qaab-dhismeedka Xafiiskooda ee la heli karo si loo soo dejiyo^{(Office templates available for download)} . Waxaan rabnaa inaan dib u isticmaalno xaashidan oo aan dhisno jilitaankayaga. Si aan taas u gaarno, waxaan rabnaa inaan hubinno inaan wax qiimo ah ku sii jirin xaashida xisaabaadka ee xogtii hore ee ay bixisay Microsoft .

Marka hore, hubi in tabka firfircoon ee ribbon ku yaal uu yahay Guriga^(Home) . Ka raadi qaybta Tafatirka^(Editing) oo halkaas ka raadi & Dooro^{(Find & Select)} liiska hoos-u-dhaca ah. Ku^(Click) dhufo Menu ka dooro " Tag Special...^{(Go To Special…)} "

Daaqadda soo baxday ee soo baxday, dooro Constant^(Constants) , ka dibna, hoosta Formulas , hubi in sanduuqa nambarada^(Numbers) oo kaliya lagu calaamadiyay.

Markaad dhammayso, dhagsii ama taabo OK .

Microsoft Excel wuxuu u socdaa inuu falanqeeyo xaashidaada oo si toos ah u dooro dhammaan unugyada ka kooban tirooyinka kaliya^{(numbers only)} , taasoo ka tagaysa unugyada aan la dooran oo ka kooban qaabab ama qoraal.

Talaabada xigta, iska hubi inaadan gujin ama ku dhufan meel kasta oo ka mid ah xaashida faafinta sababtoo ah samaynta sidaas waxay burinaysaa doorashadaada hadda. Isla qaybta Tafatirka ee ^(Editing)Home tab, guji ama taabo badhanka Clear . Badhanka waxa u taagan masax, haddii ay jirto meel bannaan oo ku filan daaqadda codsiga, ereyga Clear ayaa sidoo kale soo baxaya. Liiska hoos-u-dhaca, dooro Nuxurka Nadiifi^{(Clear Contents)} . Haddii kale, isticmaal kiiboodhka oo taabo Delete .

Xaashida xaashida ayaa hadda laga nadiifiyay dhammaan tirooyinka wax gelinta iyadoo dhammaan qaaciidooyinka la xafiday oo diyaar u ah in loo isticmaalo xaashidaada xigta. Waxaad hubsan kartaa hadda in lambar kasta oo lagu isticmaalo qaacidooyinkan ay tahay mid cusub oo aad adigu gelisey oo aysan jirin wax ka soo haray hore.

Ma^(Did) suurtagashay in aad nadiifiso xaashida faafintaada?

Ka dib markaad dhex marto hagahan, waxaad ogaan doontaa sida ay u fududahay in la nadiifiyo xaashida qiyamka wax gelinta ee duugga ah oo aad wakhti badbaadiso inaad tan si dhakhso leh oo sax ah u sameyso. Nala soo socodsii sida ay tani kuugu shaqeysay adiga oo faallo hoos kaga tagaya. Sidoo kale, ma jiraan su'aalo la xiriira Excel oo aad rabto inaan uga jawaabno casharradayada?

How to delete values from cells but keep your formulas, in Microsoft Excel

One of the blessings of working with spreadsheets in Microsoft Excel is the ability to reuse the formυlaѕ and apply them to new situations. In those cases, you wаnt to make sure you do not copy bу mistake any of the old entry values that could distort аnd taіnt the outcome. When you receive a sрreadsheet from someone else or еvеn when you work оn one of yours that contains a fair bit of complexity, yоu want to quickly isolаte аnd delete all the input values that feed the formulas that you use. Іnstead of verifying the spreadsheet cell by cell, doing grueling work, there is a method to quickly delеte all valuеs from an Excel spreadsheet and keep only the formulas. Let's see how this works:

NOTE: This tutorial applies to the desktop versions of Microsoft Excel, found in Microsoft Office, and Office 365. It does not apply to the mobile versions of Excel, like those found for free, on Windows 10 tablets, or on devices with Android and iOS.

How to delete values from cells but keep your formulas in Microsoft Excel

We use as an example the loan amortization schedule provided by Microsoft as part of their Office templates available for download. We want to reuse this spreadsheet and build our own simulation. To achieve that, we want to make sure that no values remain in the spreadsheet from the previous data provided by Microsoft.

First, make sure the active tab on the ribbon is Home. Look for the Editing section and in there locate the Find & Select drop-down menu. Click on it. In the menu select "Go To Special…."

In the pop-up window that appears, select Constants, and then, under Formulas, make sure only the Numbers checkbox is marked.

When you finish, click or tap OK.

Microsoft Excel is going to analyze your spreadsheet and automatically select all the cells that contain numbers only, leaving unselected the cells containing formulas or text.

For the next step, make sure you do not click or tap anywhere in the spreadsheet because doing so it cancels your current selection. In the same Editing section of the Home tab, click or tap the Clear button. The button is represented by an eraser and, if there is enough space in the application window, the word Clear also appears. In the drop-down menu, select Clear Contents. Alternatively, use the keyboard and press Delete.

The spreadsheet is now cleaned of all input numbers while all the formulas are preserved and ready to be used for your next spreadsheet. You can be sure now that any numbers that are used with these formulas are entered fresh by you and there are no leftovers from the past.

Did you manage to clean your spreadsheet?

After you go through this guide, you find how easy it is to clean a spreadsheet of old input values and save time doing this quickly and precisely. Let us know how this worked for you by leaving a comment below. Also, are there any Excel-related questions that you want us to answer in our tutorials?

Related posts

• Sida loo tirtiro bogga Word (6 siyaabood) -

• Sida loo doorto ama loo iftiimiyo qoraalka gudaha Windows

• Sida loo beddelo cabbirka slide ee PowerPoint: Dhammaan waxaad u baahan tahay inaad ogaato -

• Sida loo soo dejiyo faylasha Windows iyo Office ISO (dhammaan noocyada)

• Sida loo beddelo jihaynta hal bog (ama ka badan) dukumeenti Word ah

• Sida bogga internetka loogu dhejiyo barta shaqada ama Start Menu gudaha Windows 10

• Hagaaji Dhibaatooyinka Kaydka Dukumentiga Microsoft Office oo la musuqmaasuqay

• Noockee ayaan haystaa Microsoft Edge? -

• Sida loo daabaco maqaal xayeysiis la'aan dhammaan daalacashada waaweyn -

• Sida MP3 iyo faylalka kale ee maqalka ah loogu dhex geliyo bandhigyada PowerPoint

• Su'aalo fudud: Waa maxay Microsoft Sway?

• Sida loo helo, loo habeeyo, oo meesha looga saaro kordhinta Microsoft Edge -

• Sida loo beddelo browserka caadiga ah ee Windows 11 - WebSetNet

• Sida loogu daro lambarada bogga dukumeenti Word ah (laga bilaabo bogga 1, 2, 3 ama ka dib)

• Sida loo arko, loo geliyo, ama meesha looga saaro jebinta qaybta dukumeentiyada Microsoft Word

• Maxaa ka cusub Office 2016 iyo Office 365? Xagee laga soo gadayaa?

• Sida fiidyaha loo dhexgeliyo bandhigyadaada PowerPoint

• Ku samee liisaska hubinta sanduuqyada calaamadaynta, iyo sida loo tafatiro, gudaha Microsoft Word

• Sida loo geliyo oo loo tafatiro miisaska Microsoft Word ee Android

• Waa kuwee browserka ka dhigi doona batterigaaga waqti dheer gudaha Windows 10?