![remove spreadsheet converter remove spreadsheet converter](https://cybertext.files.wordpress.com/2012/04/excel_mins_secs02.png)
To do this follow the same steps as shown above and choose the relevant option from Paste Special options. Note: When you copy a cell or range of cells, you also get the option to paste only the formatting, column width, formula, data validation, conditional formatting, and everything except borders. To Paste as values – CONTROL + SHIFT + V (hold the Control and Shift keys together and then press the V key)
![remove spreadsheet converter remove spreadsheet converter](https://www.faceofmalawi.com/wp-content/uploads/2021/06/Excel-to-PDF.jpg)
You can also use keyboard shortcuts to quickly copy and paste as values in Google Sheets Keyboard Shortcuts to Copy and Paste as Values The above steps would remove the formula and you will only be left with the values. In the Paste Special options, click on ‘Paste values only’.With the cells still selected, right-click on any cell and hover the cursor over the Paste Special option.You can use the keyboard shortcut Control + C, or can right-click and then select Copy. Select the cells that have the formula that you want to convert to values (B2:B11 in this example).Suppose you have a student scores dataset as shown below and you want to convert the formula used to get the grades into values.īelow are the steps to copy the cells with formulas and convert these into values. Note: When you copy and paste a cell or range in Google Sheets, it copies and pastes not just the value but the formula as well as formatting. In this tutorial, I will show you two simple ways to convert formulas to values in Google Sheets. I am sure there can be many more such situations in which converting a formula to value is the right thing to do. The formulas are no longer needed and you want to convert these to values to speed up your Google Sheets document.You want to share your Google Sheet with a colleague or client and don’t want them to mess up the formula (or if you only want to share the values and keep the formula to yourselves).You have used the RAND or RANDBETWEEN functions to create a list of random numbers and you only want the values and not these cells updating/changing every time there is a change in the sheet.You want to copy and paste data in different places on the same sheet (or in a different sheet) without having the formula to adjust the references and show different results or errors.Here are some likely scenarios when this might be needed: While formulas are awesome, there might be some cases when you want to convert formula to values in Google Sheets.