Column Formula + Reports
Curious why a column that has a formula applied cant be changed when it's pulled into a report - from the report?
Also wondering if there is a way that is quick to remove the formula from an entire column? I've switched one back to 'cell formula' to allow for edit from the report but, would like to avoid running down 600 cells to manually remove the formula from each.
Best Answer
-
Yes. It will delete the data since you are deleting the formula. If you want to keep the data but remove the underlying formula, you will need to convert it to a cell formula, copy all of the cells, then "Paste Special / Values".
Answers
-
Once changed to a cell formula, you can click on the column header to select the entire column and then hit the delete key on your keyboard.
-
Will that also delete the data in the cell? Its a date column.
-
Yes. It will delete the data since you are deleting the formula. If you want to keep the data but remove the underlying formula, you will need to convert it to a cell formula, copy all of the cells, then "Paste Special / Values".
-
Thank you @Paul Newcome
-
-
Can the "Paste/Special Value" work with sheets that have more than 500 rows? we need to replace formula with the value only for over 6000 rows.
Help Article Resources
Categories
Check out the Formula Handbook template!
