Excel Tutorial - Convert formulas to values

LinkedIn Learning is the next generation of Lynda.com. Grow your skills by exploring more Excel courses today: www.linkedin.com/learning/top...
#Excel
#HowTo
#LinkedIn

[@juliusalistado8404]

what if Column B has filters and you only want the visible cells to be changed to values? I don't want the hidden cells formula to be messed up. Please help.

[@dipeshjoshi2316]

Is this do able with a formula. Just because I dont want to have to copy and paste. Instead auto generate as a value into another cell?

[@rmhutchins7]

I enjoyed your video. It was very helpful. Thank you!

[@philcole8804]

thank you again! helped me 2 times..

[@aneilrk]

how do I pick values from Formulae

[@techiegz]

How do you grab the result or value of the formula but keep the formula in place?

[@leonardostreit3527]

Hello, thank you for your help, although I think it doesn’t work in recent versions anymore.

[@HollywoodMoviesDubbedinHindi]

Thank you so much. Nice Useful Information

[@deansservices3724]

Worked great, thank you.

[@Trey_D_2023]

wow..awesome tip! helped me a lot! thanks.

[@Kcx.1]

Very helpful , thanks !

[@mirsvima2023]

Thanks a lot!

[@narendraprasad2601]

thank you for your help

[@vivekchoudhary5120]

thank you sir .:)

[@shortguruji]

Thanks, I have done

[@ssinghal00]

thank you for this :)

[@eagillum]

Thanks!

[@sjbealeelts]

thanks :)

[@navedkhan-qt5ic]

Nice sr

[@joen5000]

How can that be made automatically and not manually as you did?
What I mean, let's say you want to create another column with the names and not the formulas, but if you change the names, you would like values in the copied cells to change as values not as formulas?
In your case, let's say I want to copy the values alone from B2, B3... to column J as J2, J3... but in column J they should appear as values alone, not formulas. The method of typing in J2 the following: =B2 doesn't work. It thought gives names, but in form of a formula and not in a form of a pure value.

[@ereisenheim9896]

I have the exact problem and countless videos I've watched till now resolve it only with manual intervention, while I 'm in need of something that does it automatically.