How to Remove Formula in Excel - Remove Excel Formulas FAST [Quick Excel Tips]

In this short video, learn how to remove Excel formula but keep data intact. See the pinned comment for written steps.

✂- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

✂- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Check out these playlists for more from Data Savvy TV:

VLOOKUP Tutorial Series

SQL Tutorial for beginners

How to Become a Data Analyst - Data Analytics Training for Beginners

✂- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Data Savvy TV Website:

✂- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Data Savvy TV Social Media links on my main page (check the banner in the top right corner):

✂- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
About this video:

Ever need to get rid of a formula but still keep the result of the formula? In this Quick Excel Tips video, Vanessa quickly demonstrates an Excel shortcut showing you how to remove excel formulas quickly and easily.

✂- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
About Data Savvy TV:

With the number of analytics jobs growing faster than the available talent, it is becoming increasingly important to provide accessible advice to anyone wanting to become a data analytics professional.

This channel's mission is to empower others with knowledge and resources to become data analytics professional while building a community around learning these skills and collaborating with others from beginners to experts. It's an extremely supportive community in real life, and here this channel serves as a platform to create that community online.

✂- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
About Data Savvy TV Creator, Vanessa Ynzunza:

Affiliate Link Notice: This video and description contain affiliate links, which means that if you click on one of the product links, I’ll receive a small commission at no extra cost to you. This helps support the channel and allows us to continue to make videos like this. Thank you for the support!

#DataSavvyTV #ExcelTutorials #Excel

[DataSavvyTV]

For those who like written steps, here you go :)
1) Enter a formula
2) Click on black box in bottom right corner to fill column with formula
3) Select Cells or Columns containing formulas
4) Move mouse to EDGE of selection, until cursor changes to black cross, then...
5) RIGHT-CLICK, HOLD and move away from cells/columns and back
6) Select Copy Here as Values Only
7) Formulas are now replaced with values
TADA!! ~*~ Excel magic ~*~ :)

[yarsftks]

Select, right-click drag and drop in same place, select "Copy Only Values". Brilliant. Thank u. This will help at work.

[triciapeng]

this is what i am looking for! Most of other videos only use the paste special function which would change the cell format, but this skill doesn't change the format and simple! Thank you very much!

[ZAKtalksTECH]

My Excel skills are terrible, and I don't have the time to watch really long tutorial videos. So quick videos like this, that get to the point and teach, are great! Adding to my "Excel help" folder! Thanks!

[asureshkumarin]

This is really quick & easy. Thanks so much 👍

[mrdigitalau]

Absolutely fantastic tip. Learnt something new today :D

[CzechFlash]

great to see you back, thanks for the tip:)

[willchambers]

Yes! This is a great tip. Thanks so much!