Microsoft Excel waa mid ka mid ah barnaamijyada softiweerka ah ee aadka loo isticmaalo kaas oo kuu ogolaanaya inaad maareyso xogtaada oo kuu sahlaysa adiga oo kaashanaya qaababka. Si kastaba ha ahaatee, markaad rabto inaad nuqul ka sameyso oo aad dhejiso qiyamka aad hore ugu xisaabisay qaacidooyinka. Laakin, markaad koobiyayso qiyamkan, waxaad sidoo kale koobiyaysaa qaacidooyinka. Ma noqon karto mid aad u faraxsan markaad rabto inaad koobiyayso qiyamka, laakiin sidoo kale waxaad ku dhejisaa qaacidooyinka oo ay la socdaan qiyamka. Nasiib wanaag, waxaan haynaa hage ku saabsan koobiyeynta iyo dhejinta qiyamka iyada oo aan la hayn qaacidooyin ku jira Excel^{( copying and pasting values without formulas in Excel)} oo aad raaci karto si aad u nuqul ka sameyso oo aad u dhejiso qiyamka iyada oo aan la isticmaalin.

Sida loo dhajiyo qiyamka la'aanteed foomamka gudaha Excel^{(How to Paste Values Without Formulas in Excel)}

Habka 1: Isticmaal habka koobi-ku dhejinta^{(Method 1: Use the copy-paste method)}

Waxaad si fudud u koobi kartaa oo dhejin kartaa qiyamka la'aanteed qaab- dhismeedka Excel^(Excel) adiga oo isticmaalaya koobi iyo dhejinta ikhtiyaarrada qaybta sabuuradda.

1. Fur xaashida Microsoft Excel^{(Microsoft Excel sheet)} .

2. Hadda, dooro qiyamka aad rabto inaad nuqul ka sameyso oo ku dhejiso unug kale ama xaashi kale.^{(Now, select the values you wish to copy and paste to another cell or sheet.)}

3. Kadib markaad xulato unugga, dhagsii home tab^{(click on the home tab)} qaybtaada sabuuradaha ee xagga sare oo dooro koobiga. Xaaladeena, waxaynu koobiynaynaa qiimihii aanu ku xisaabinay qaacidada SUM . Hubi shaashadda si aad tixraac u hesho.

4. Hadda, tag qolka aad rabto inaad ku dhejiso qiimaha.

5. Qaybta sabuuradda, dhagsii liiska hoos-u-hoosaadka ee hoose ee dhejiska.^{(click on the drop-down menu below paste.)}

6. Ugu dambeyntii, waxaad riixi kartaa qiyamka (V) ee hoos yimaada qiyamka dhejiska^{(click on values (V) under paste values)} si aad u dhejiso qiimaha unugga adigoon wax qaacido ah lahayn.

Sidoo kale akhri: ^{(Also Read:)} Sida loo beddelo tiirarka ama safafka gudaha Excel^{(How to Swap Columns or Rows in Excel)}

Habka 2: Isticmaal Kutools add-in ^{(Method 2: Use Kutools add-in )}

Haddii aadan aqoon sida si toos ah loogu koobi karo qiyamka sare, ma aha qaacidooyinka, waxaad isticmaali kartaa Kutools kordhinta ee Excel . Kutools for Excel waxay ku imaan karaan anfaca markaad rabto inaad nuqul ka sameyso qiyamka dhabta ah adigoon haysan qaacidooyinka.

1. Soo deji Kutools^{(Kutools )} add-in for your excel.

2. Kadib markaad si guul leh u rakibto add-in, fur xaashida Excel oo dooro qiyamka aad rabto inaad nuqul ka sameyso.^{( installing the add-in, open your excel sheet and select the values you wish to copy.)}

3. Samee midig-guji oo nuqul ka samee qiimaha.

4. Tag unugga si aad u dhejiso qiimaha oo samee midig-guji si aad u dhejiso qiimaha.^{(right-click to paste the value.)}

5. Hadda, ka saar qaacidada qiimaha. Guji ^(Click)tab Kutools^{(Kutools tab)} xagga sare oo dooro To Xaqiiqda.^{(select To Actual.)}

Ugu dambeyntii, shaqada dhabta ah waxay ka saari doontaa qaacidooyinka qiyamka aad dhejinayso.

Su'aalaha Inta Badan La Isweydiiyo (FAQs)^{(Frequently Asked Questions (FAQs))}

Ma koobiyayn kartaa tirooyinka bilaa qaabab?^{(Can you copy numbers without formulas?)}

Waxaad si fudud u koobi kartaa nambarada adigoon qaacidooyin lahayn. Si kastaba ha ahaatee, waa inaad isticmaashaa shaqada qiyamka dhejiska si aad u nuqul ka sameyso oo aad u dhejiso tirooyinka iyada oo aan la isticmaalin. Si aad u koobiyaysid nambarada bilaa qaacido, koobbi nambarada aad rabto inaad nuqul ka sameyso oo guji liiska hoos u baxa ee ku hoos jira batoonka dhejiska ee qaybta sare ee sare ee sare. Laga bilaabo liiska hoos-u-hoosaadka, waa inaad gujisaa qiyamka hoos yimaada qiyamka dhejiska.

Sideen meesha uga saaraa caanaha oo aan u dhejiyaa qiyamka Excel?^{(How do I remove formula and paste values in Excel?)}

Si aad meesha uga saarto qaacidada oo kaliya ku dheji qiyamka ku jira Excel , koobiye qiyamka oo aad qaybta sabuuradda. Hoosta guriga>guji liiska hoos-u-hoosaadka ee ku hoos jira badhanka dhejiska. Hadda, dooro qiyamka hoos yimaada qiimaha dhejiska si aad u dhejiso qiimaha iyada oo aan la haysan qaaciddada.

Sideen ugu qasbaa Excel inuu dhejiyo qiyamka oo keliya?^{(How do I force Excel to paste values only?)}

Waxaad isticmaali kartaa ku -darka Excel ee loo yaqaan Kutools for Excel , kaas oo kuu ogolaanaya inaad nuqul ka sameysid oo aad dhejisid qiyamka dhabta ah iyada oo aan la helin qaababka. Waxaad si sahlan u raaci kartaa hagahayada faahfaahsan si aad u isticmaasho Kutools add-in.

lagu taliyay:^{(Recommended:)}

• Sidee Loo Xidhaa Ama Loo Furaa Unugyada Excel?^{(How To Lock Or Unlock Cells In Excel?)}
• Hagaajin Windows 10 badhanka bilawga ah oo aan shaqaynayn^{(Fix Windows 10 Start Button Not Working)}
• Sida looga saaro erayga sirta ah ee Excel File^{(How to Remove Password from Excel File)}
• Hagaaji Isha Chromecast Aan Aan La Taageerin Aaladaada^{(Fix Chromecast Source Not Supported Issue on Your Device)}

Waxaan rajeyneynaa in hagahan uu waxtar lahaa oo aad awooday inaad koobiyeyso oo aad dhejiso qiyamka adigoon habab ku jira Excel^{(to copy and paste values without formulas in Excel)} . Weli, haddii aad wax shaki ah ka qabtid, markaa xor ayaad u tahay inaad ku waydiiso qaybta faallooyinka.

How to Copy and Paste Values Without formulas in Excel

Microsoft Excel is one of the most used spreadsheet software programs that allows you to mаnage your data and makes things easy for you with the help of formulas. However, when yoυ want to copy and paste the values уou earlier calculated with formulas. But, when you cоpy these values, you copy the formulas as well. It cannot be very pleasant when you want to copy-рaѕte the values, but you also paste the formulas along with the values. Fortunately, we have a guide on copying and pasting values without formulas in Excel that you can follow to copy and paste the values without formulas.

How to Paste Values Without Formulas in Excel

Method 1: Use the copy-paste method

You can easily copy and paste the values without formulas in Excel using the copy and paste options from your clipboard section.

1. Open the Microsoft Excel sheet.

2. Now, select the values you wish to copy and paste to another cell or sheet.

3. After selecting the cell, click on the home tab from your clipboard section at the top and select copy. In our case, we are copying the value that we have calculated with the SUM formula. Check the screenshot for reference.

4. Now, go to the cell where you wish to paste the value.

5. From your clipboard section, click on the drop-down menu below paste.

6. Finally, you can click on values (V) under paste values to paste the value in the cell without any formula.

Also Read: How to Swap Columns or Rows in Excel

Method 2: Use Kutools add-in 

If you don’t know how to automatically copy excel values, not formulas, you can use the Kutools extension for Excel. Kutools for Excel can come in handy when you want to copy the actual values without the formulas.

1. Download Kutools add-in for your excel.

2. After successfully installing the add-in, open your excel sheet and select the values you wish to copy.

3. Make a right-click and copy the value.

4. Go to the cell to paste the value and make a right-click to paste the value.

5. Now, remove the formula from the value. Click on the Kutools tab from the top and select To Actual.

Finally, the actual function will remove the formulas from the values that you are pasting.

Frequently Asked Questions (FAQs)

Can you copy numbers without formulas?

You can easily copy numbers without formulas. However, you have to use the paste values function to copy and paste the numbers without formulas. To copy the numbers without formulas, copy the numbers that you wish to copy and click on the drop-down menu under the paste button in your excel clipboard section at the top. From the drop-down menu, you have to click on values under paste values.

How do I remove formula and paste values in Excel?

To remove the formula and only paste the values in Excel, copy the values and go to your clipboard section. Under home>click on the drop-down menu under the paste button. Now, select values under the paste value to paste the value without the formula.

How do I force Excel to paste values only?

You can use an Excel add-in called Kutools for Excel, which allows you to copy and paste the actual values without the formulas. You can easily follow our detailed guide to use the Kutools add-in.

Recommended:

• How To Lock Or Unlock Cells In Excel?
• Fix Windows 10 Start Button Not Working
• How to Remove Password from Excel File
• Fix Chromecast Source Not Supported Issue on Your Device

We hope this guide was helpful and you were able to copy and paste values without formulas in Excel. Still, if you have any doubts, then feel free to ask them in the comment section.

Related posts

• Koobiyi Paste ma shaqaynayo Windows 10? 8 siyaabood oo loo hagaajiyo!

• Hagaaji Soo Celinta Xogta. Sug dhowr ilbiriqsi oo isku day inaad mar kale gooyso ama nuqul ka sameyso qaladka Excel

• Sida Looga Badalo Saafka ama Saafka Excel [Tallaabo Talaabo]

• Fix Excel wuxuu sugayaa codsi kale si loo dhamaystiro ficil OLE

• Sidee Loo Xidhaa Ama Loo Furaa Unugyada Excel? (2022)

• Sida Loo Beddelo Erayga JPEG (3 Siyood)

• Sidee Loogu Wareejin karaa Microsoft Office Kombiyuutar Cusub?

• Sida loo isticmaalo Hubiyaha Helitaanka ee Xafiiska Microsoft

• Sida Loo Abuuro Indent-ka Laalaada ee Word iyo Google Docs

• 4 Siyaabaha Loo Geliyo Calaamadda Degree ee Microsoft Word

• Sida loo koobiyo oo loogu dhejiyo PuTTY (2022)

• Sida loo sawiro Microsoft Word 2022

• Sida looga saaro erayga sirta ah ee Excel File

• Sida loo Gelida Line gudaha Word

• Sida loo soo celiyo farriimaha la tirtiray ee Microsoft Office

• Ku samee foomamka la buuxin karo Microsoft Word

• Waa maxay faylka XLSX & Sida loo furo faylka XLSX?

• Hagaaji qaladka Excel stdole32.tlb gudaha Windows 10

• Sida Loo Soo Kabsado Arrimaha Musuqmaasuqa Xogta ee Microsoft Outlook

• Hagaaji qaladka Ogolaanshaha Faylka Word gudaha Windows 10