Remove All Formulas from an excel sheet and Keep Values (using Shortcuts)

What is the shortcut to remove formula and keep values in Excel? Watch this video and learn how to remove all formulas from an Excel Sheet without deleting values.
Thanks for watching this video.
Feel free to comment your questions. You can also request topics.
Connect with me on :
Twitter : / the_akshay_1
FB : / theakshay2
#Excel_Series #MsExcel #ExcelTutorial

[@ashwinbhaskar8945]

Thanks so much bro. god bless you

[@TheAkshay]

I'm glad you found it useful.

[@RohitKumar-oy5tl]

Bikul correct half and hour se dhund rha tha video shi video mil gya

[@londiweayandamakhubo1601]

Life saver, it it was possible I was going to like your videos again and again

[@TheAkshay]

It is great to know that my video helped you!

[@harsvinkumar7459]

Tq bro straight to the point

[@surjitsinghshairi6414]

Thanks dear this helps me a lot god bless

[@joybanerjee3]

Really saved my time ❤ God bless you

[@TheAkshay]

Thanks for feedback

[@sumitsutradhar2085]

Thank you so much for this information 👍👍

[@thesimplewonders1918]

Thanks so much Akshay

[@FirozddjketgwKhanking]

Thank you sir 🙏🏻

[@Sanathanavihari]

Thank you bro for helping

[@negishubham]

Informative

[@manishthakur4967]

Thanks for giving your knowledge to us

[@TheAkshay]

I'm happy that it is helping

[@saikumarchinnaanarashi1195]

Thank you bro🎉

[@SRLeo1111]

Thank you!!

[@shujasaifi6519]

bohot khoob very short and informative video very nice
🤩🤩

[@TheAkshay]

Nice to see that someone is noticing my efforts!

[@LovelyBonsaiTree-co4pc]

Very good sir I do this
It's very working thing ❤

[@TheAkshay]

Welcome dear

[@shahrukhshaikh2264]

Thankyou so much bro it really helped me a lot

[@TheAkshay]

Good to know

[@ashpakshaikh2635]

Thanks sir, its really helped me a lot.

[@TheAkshay]

Glad to hear that

[@user-ry5jp5cy6b]

Very needfull this video

[@applepakistan3164]

Allah Bless You, Bro

[@dimplerajputarts178]

thanks so much it helped ☺️☺️❤️

[@TheAkshay]

Thanks for your feedback

[@sahalvhora5185]

wow bro thnks

[@iconservices1721]

THANX BRO

[@powervind]

nice video.. how to do this without using mouse ?? I mean any formulae to keep the value

[@raj-khotmarathawarriorclan]

Very well put ....thnx

[@TheAkshay]

🙏🏼

[@mayurijadhav779]

Thanks for info

[@TheAkshay]

You're welcome

[@GogreenGosolar123]

Tq ❤

[@premghosh1997]

Thank you 🙏

[@TheAkshay]

Welcome

[@jeevaneknaeesoch9873]

TQ bro

[@rohithg5654]

Thank you

[@TheAkshay]

Welcome!

[@joybanerjee3]

Thankyou 🙏

[@TheAkshay]

Welcome

[@pranayjagtap5178]

Thanks bhai

[@TheAkshay]

You're welcome

[@varaddudhe804]

Thanks

[@TheAkshay]

Welcome

[@subhodeepbiswas2827]

Select all, copy all and click alt+e+s+v

[@maahi8846]

Thankyou somuch

[@TheAkshay]

Welcome

[@pramoddubey4939]

Nice 👍🏻👍🏻👍🏻👍🏻

[@TheAkshay]

Thank you 👍

[@parmeshwarsutar7824]

Thank u sir

[@TheAkshay]

You're welcome

[@hassanabassafridi3415]

good

[@manikandaprabu2550]

Super

[@TheAkshay]

Thanks

[@rez752]

Ok, but then when I want to use the formulas again, what do I do?

[@vinaybhatt2095]

Sir ek Excel mein data bana rhka hai aur mujhe new sheet mein dalna hai but prblm yeh hai ki purni table mein formula laga hai but nhi ho paa rha new sheet m

[@pankajchaudhari464]

Nice job pareshan tha 😂

[@TheAkshay]

Check out my other helpful videos!

[@nikhilmasand5016]

bro i don't have 'end' on my keyboard, is there any other alternative to that?

[@oliver_comp]

This question asked in the interview but in the piovot table . I know this method but not the pivot table method 😢

[@mukeshbeniwal7680]

Or formula bapisa kese laye jo remove kiya tha

[@amankhan1786]

Not. Select dada using ctrl+shift+end key

[@TheAkshay]

Best way to select all cells that contain data on your Excel sheet is to use the CTRL+SHIFT+END keyboard shortcut.

[@vickybais7273]

Why ? I think we must put curser where you have written date and hold control+a it is great

[@sandv2902]

Not working

[@thakurfflover1971]

Fake h yah

[@fulldhamal213]

Not helpfull this video

[@sunnytagger8359]

Bekar video

[@laxmansharma3796]

THANKS ❤‍🩹

[@TheAkshay]

Welcome

[@TheShababfire]

Thanks a lot sir❤

[@TheAkshay]

Most welcome