clear cell

Morning all (well, it is morning here). So I'm using O365 and I'm wondering if there is any way to have excel clear a cell (lets say D16) when you make ANY selection from a drop down box located in another cell? And continuing on from that, as well as clearing a cell so that it contains...

Hi everyone, Basically, I have a list of names and reasons for people being on a list. Plus the date their names were added to the list. What I'm wanting is for the line with their info to be removed after 7 days when we open the spreadsheet. Referring to the image, lets take row 2-4. Their...

I have a situation where I'm wanting to clear the cell from Column A if it equals A, B, or C and also check that if D is not blank to clear that cell also for the entire sheet. Thank you in advance! COL A COL B COL C COL D c value value value clear A and D b value value clear A only...

Hi all, I have a sheet that has many protected cells on it and then to the right of those protect cells are unprotected cells to put our daily usage totals in. After filling out the sheet we print it and then we need to clear the contents within the unprotected cells and start over for the next...

please help me.. i programmed cell k13 to remind me "billing due" if i have paid my bills or not using today() function..if we paid, we need to type "paid" into n13 and it should clear the text in k 13..if we haven't yet paid we need to type "not paid" and it should say "Billing due" these are...

Hello I'm kind of new to Excel and I need help. I'm importing values to a table through a Query, but some of these values are incorrect and I would like them cleared. How do I tell Excel to automaticly clear all cells with the value "1901-01-01 01:01:01"? Thank you for helping.

I have four cells that are are dependent of each other using Data Validation. When I change the cell in column C it updates the pull down list in column D. This continues through F. The problem is that if I have all of this information filled in and I decide to start over by changing the cell...

Hi Guys & Girls, I have a spreadsheet that contains various many cells with text contained in them. I want to be able to find all cells that contain "P001" and clear the entire cell, not just the "P001". For example I might have 3 cells (see below), I would want a macro to clear the 2 cells...