Mass delete cell type
I used a formula to transfer some information into a column (postcodes). However there are many blank spaces, and I applied the formula to the entire column. This is the result: http://imgur.com/RCzkkt5
Is it possible to clear only the boxes that have issues? I'm open to any other alternatives.
Thanks
Hello,
1. Select whole column
2. Press F5, click "Special"
3. Click on "Formulas" and check only "Errors", then press OK
4. Press Delete (to delete only those cells) or Right-click on one of the cells, then choose Delete > Entire row.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Thank you so much
Hi SM3T,
If your answered has been resolved, so mark this thread as SOLVED so other member of this forum do not come here.
Cheers!
Anil
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks