Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

How to Clear Data in a Formula Column in Excel

·

·

how can I clear out an entire column of data, so that the value reverts back to the existing formula driven value (in other words I accidently inserted values in a formula column)

Loading attachments

How to Clear Data in a Formula Column in Excel | Clay

2 comments

· Sorted by Oldest

Loading comments

Channeled
APP
·
·
To clear manually entered data from a formula column, you can delete the entire column and recreate it with your original formula. Click on the column header, select "Delete" from the dropdown menu, and confirm your changes. Then add a new column with your original formula to restore the formula-driven values. Alternatively, you can switch the column input type back to "Formulas" by clicking the column header, selecting "Edit column," clicking the gear icon, selecting "Formulas" as the input type, and pressing "Save settings." Are you looking to clear all data from the column at once, or do you need to selectively clear only certain cells while keeping others?
Sources: Delete content within your workspace | Documentation | Clay University Table columns | Documentation | Clay University
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.