This seems like a dumb question, but I can’t seem to find a quick way so I hope some of you can help?
I have a base with many hundreds of records on it. The first column is all data that I need to get rid of. I can’t delete the column as it is the mandatory one. So I need a quick way to just clear the data in column 1.
All I seem to be able to do is select and drag down to select multiple cells in the column to then be able to delete the data and this is taking a very long time due to the number of records in the table!
Is there a more efficient way to do this?