I need to delete all blank cells from a column of data but excel won't let me. I'm able to select through Go To - Special - Blanks but I'm not sure how to delete them all at once. The delete cells button is always not lit up every time I try
Solved by B. U. in 16 mins